Hey I was wondering there was a way to plot two series' on a line chart that have different intervals. A simple example could be the following:
Series 1:
Day: 1 Sales: 50
Day: 3 Sales: 25
Day: 4 Sales: 55
Day: 6 Sales: 60
Series 2:
Day: 1 Sales: 45
Day: 2 Sales: 35
Day: 4 Sales: 55
Day: 5 Sales: 70
How would one plot these so that the x-axis was the days and the chart would just skip the necessary days and plot the lines with the available data points?
you need to lay out your data like this:
Column A
Titles, i.e. day 1 through to day 6
Column B
series 1 data in the respective rows
Column C
series 2 data in the respective rows
Then select your data and the titles and create a line chart. Might be best to use the line chart with markers. Then, with the chart selected, go Tools - Options and on the Chart tab click "plot empty cells as interpolated". This will connect the data points even if a value of a cell is missing.
Note that the chart tab in Tools - Options is only visible when a chart is selected, and that interpolation can only be selected for certain chart types.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks