Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
maztaz
 
Posts: n/a
Default values in Y axis changes to percentage


Why do the dollar values change to a percetage when I change the chart
type from a clustered column chart to a Stacked Column chart?


--
maztaz
------------------------------------------------------------------------
maztaz's Profile: http://www.excelforum.com/member.php...o&userid=33741
View this thread: http://www.excelforum.com/showthread...hreadid=535172

  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default values in Y axis changes to percentage

I think you are using the 100% cluster subtype in error. Try the second
subtype
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"maztaz" wrote in
message ...

Why do the dollar values change to a percetage when I change the chart
type from a clustered column chart to a Stacked Column chart?


--
maztaz
------------------------------------------------------------------------
maztaz's Profile:
http://www.excelforum.com/member.php...o&userid=33741
View this thread: http://www.excelforum.com/showthread...hreadid=535172



  #3   Report Post  
Posted to microsoft.public.excel.charting
maztaz
 
Posts: n/a
Default values in Y axis changes to percentage


Thanks for that. So simple. As you'll have picked up, it's all pretty
new but I'm getting there. I was trying to copy an exercise in our
course and the 3rd subtype seemed to be the one we had to use.


--
maztaz
------------------------------------------------------------------------
maztaz's Profile: http://www.excelforum.com/member.php...o&userid=33741
View this thread: http://www.excelforum.com/showthread...hreadid=535172

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
set default axis values brian thompson3001 via OfficeKB.com Charts and Charting in Excel 3 March 13th 06 04:48 PM
Y Axis is repeating values - can't figure out why fuzzyfreak Excel Discussion (Misc queries) 2 March 7th 06 11:50 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Chart to report frequency of a value as a percentage of values johnnyrover Charts and Charting in Excel 1 August 27th 05 04:55 PM
Can I add values, labels and percentage for pie charts? coops-eng Charts and Charting in Excel 1 February 1st 05 04:23 PM


All times are GMT +1. The time now is 12:57 PM.

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"