Charts sums 2 data series

S

Sig74462

Have 2 col of data and names 2 data series. But the second series is a total
of the first no. plus the second no. I want each col to be a separate line
on the chart.
 
J

Jon Peltier

Right click on the chart, choose Chart Type (or Change Chart Type
depending on Excel version), pick the first subtype, which is just
arbitrary series, not the second, which is stacked, or the third, which
is stacked to 100%.

- Jon
 

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

Top