ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-27-2005, 08:06 PM
Daniell
Guest
 
Posts: n/a
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.
Reply With Quote
  #2  
Old 01-28-2005, 01:06 AM
Sam Snow
Guest
 
Posts: n/a
RE: Chart type

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.

Reply With Quote
  #3  
Old 01-28-2005, 06:06 PM
Daniell
Guest
 
Posts: n/a
RE: Chart type

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 With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 12:28 AM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0