#1   Report Post  
Daniell
 
Posts: n/a
Default 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   Report Post  
Sam Snow
 
Posts: n/a
Default

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   Report Post  
Daniell
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart formatting Christianovitch Charts and Charting in Excel 1 January 19th 05 10:55 PM
Pivot Chart: cannot apply the default chart type... doco Charts and Charting in Excel 1 January 17th 05 04:55 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 5th 05 11:25 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"