Hallo,
I want to create step chart/ panel chart that compares data from 2 years. I amusing the ‘line chart approach’ as outlined in http://peltiertech.com/Excel/ChartsHowTo/StepChart.html
I am finding that only one data series comes out as a step chart while the second series stays a basic line chart.
Are there any additional steps that are not included in the above article?
Thanks!
Hello,
The blue line is not set up with the correct source data. For the pink line you are plotting two ranges where the X axis points start in A35 and C36, so the dates are repeated and create a step pattern.
For the blue line the selection is all over the place and also selects data in the same column twice.
Insert two columns after J. Copy and paste the data starting in I16:J224 and copy into the new columns. Then edit the chart source and change the 2014 series to the Series values
=(Data2!$L$16:$L$192,Data2!$J$16:$J$193)
Change the X axis label source to
=(Data2!$K$16:$K$193,Data2!$I$16:$I$193)
See attached.
cheers, teylyn
Hallo Teylyn,
Thank you very much for the detailed instructions. I was not aware that things got messed up to such a degree.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks