Help! I'm losing one series of data in an overlay chart.
I have 5 series of data, one is different from the first four. I create them
all in a column chart then edit the one different series to be a combination line on the column chart with a secondary axis. When I do that I lose one whole data series of the 4 similar ones. It is recognized by excel but not plotted. It seems almost like excel only wants to plot 3 series as a column and the others have to be a line, but I know this chart is possible, I've seen it elsewhere. Help! |
Instead of changing the chart to a combination line, try changing the series
that you want to show as a line to an XY Scatter Chart with the option "Scatter with data points connected by lines". ---- Regards, John Mansfield http://www.pdbook.com "Charts are Us" wrote: I have 5 series of data, one is different from the first four. I create them all in a column chart then edit the one different series to be a combination line on the column chart with a secondary axis. When I do that I lose one whole data series of the 4 similar ones. It is recognized by excel but not plotted. It seems almost like excel only wants to plot 3 series as a column and the others have to be a line, but I know this chart is possible, I've seen it elsewhere. Help! |
All times are GMT +1. The time now is 03:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com