View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Data Charting Correctly

Choose the line chart option in the first column, not the stacked line chart
option in the second.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"tmvigil95" wrote in message
...
We are working with a table that has a Sell Price, List Price, and Profit
Margin. When we try to chart it, it looks like it is adding the "Sell
Price"
and "List Price". The "Sell Price" which is in row 1, is plotted
correctly.
The "List Price" looks to be the total of the two. The "Profit Margin" is
plotting with the "List Price".

Is it in the way we have selected the table to chart? Does anyone have
any
suggestions?