ONE Chart Data Series from TWO worksheets

[NamssoB]

I'd like to track data from TWO worksheets, in ONE data series in a chart. Is this even possible?

I have a business mileage tracker that is tracking spending. A 2nd worksheet was created when I switched cars. I'd like to "append" the same column/data form the end worksheet to the end of the chart already showing the data form the 1st worksheet. Can this be done?

For example:

Chart data range: 'Mileage - Sheet1'!$A$2:$A$849,'Mileage - Sheet1'!$E$2:$E$849

Now I want to pick up as if $A$2 in Sheet2 is the next data point.

??

 

[tusharm]

You have lots of choices. Here's the easiest of the lot, if it works for you.

If column A contains dates, just plot the 2 data sets as different series in a XY Scatter Chart and Excel will correctly plot the data so that the 2nd series picks up where the first leaves off.

I'd like to track data from TWO worksheets, in ONE data series in a chart. Is this even possible?

I have a business mileage tracker that is tracking spending. A 2nd worksheet was created when I switched cars. I'd like to "append" the same column/data form the end worksheet to the end of the chart already showing the data form the 1st worksheet. Can this be done?

For example:

Chart data range: 'Mileage - Sheet1'!$A$2:$A$849,'Mileage - Sheet1'!$E$2:$E$849

Now I want to pick up as if $A$2 in Sheet2 is the next data point.

??

 

[NamssoB]

OK, this seems to work - not as pretty as what I had before, but it works. Thank you!

 

[tusharm]

You are welcome.

OK, this seems to work - not as pretty as what I had before, but it works. Thank you!