Help! I'm losing one series of data in an overlay chart.

G

Guest

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!
 
G

Guest

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign data series to primary axis 1
User Selectable Series and Number of Series for Line Chart 2
Overlaying 2 Data Series with Different Time (X) Axis 3
Not plot a data series in a chart but still display in data table 1
To plot 3 series each with 90000 data in single Line or XY chart. 4
Chart series 1
Eliminate "white space" at edge of area chart data series 2
Combination chart: primary data labels obscure line series on secondary axis 3

Top