Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart type
I have been asked to provide a chart to management that would show cost, sale
price and quanity. The problem is that the values are very different . For example the cost could be $800., and the sale price could be $1400 and the quanity could be 80. Is there a type of chart that can be used to show these figures? Thanks in advance for the help. |
#2
|
|||
|
|||
Daniell - Are you displaying trend data (data over a period of time)? If so,
you might consider putting the two data points that are close in range on one axis and put the third data point on a secondary axis. Using a secondary axis will put another number line on the right of your chart with a different scale. Another suggestion is to decide which piece of info is the most important, and make it the main chart. Then embed the other info on two more smaller charts and show them all in the same window. Not sure if that will help. Good luck. "Daniell" wrote: I have been asked to provide a chart to management that would show cost, sale price and quanity. The problem is that the values are very different . For example the cost could be $800., and the sale price could be $1400 and the quanity could be 80. Is there a type of chart that can be used to show these figures? Thanks in advance for the help. |
#3
|
|||
|
|||
Yes the data is trend so I will give that a try. Thanks!
"Daniell" wrote: I have been asked to provide a chart to management that would show cost, sale price and quanity. The problem is that the values are very different . For example the cost could be $800., and the sale price could be $1400 and the quanity could be 80. Is there a type of chart that can be used to show these figures? Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart formatting | Charts and Charting in Excel | |||
Pivot Chart: cannot apply the default chart type... | Charts and Charting in Excel | |||
Adding a line Chart Type to a stacked-clustered Chart Type | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |