series graph -- one series being added to another series

  • Thread starter rich zielinski via OfficeKB.com
  • Start date
R

rich zielinski via OfficeKB.com

I have a graph with three series all pulling from another spread sheet.
the first series plots correctly on the y axis
the second series plots higher up on the y axis instead of at corresponding
values on the y axis. It appears the second series is being added to the
first and plotted at the combined values.
when I look at the plot point for the second series; for example $25000
is being plotted at $50000 on the Y axis even though it is saying $25000.
Help me please!!!!!!!
 
G

Guest

Assuming you're using a column chart, check to see if you've chosen the
stacked column chart option. If so choose the clustered column chart option.

If you're using a bar chart, change it from a stacked bar to a clustered bar.
 
R

rich zielinski via OfficeKB.com

I changed the graph type --I was using a stacked line type.
Oh man--I would have never found this unless you told me.
Thanks.
 

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