Chart type

[Daniell]

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.

 

[Sam Snow]

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]

Yes the data is trend so I will give that a try. Thanks!