Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data Charting Correctly
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data isn't imputting correctly | Excel Discussion (Misc queries) | |||
Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
data is not filtered out correctly... | Excel Discussion (Misc queries) | |||
Imported Data, How to delimit correctly | New Users to Excel | |||
Formatting web imported data correctly | Excel Worksheet Functions |