ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   values in Y axis changes to percentage (https://www.excelbanter.com/charts-charting-excel/84582-values-y-axis-changes-percentage.html)

maztaz

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


Bernard Liengme

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




maztaz

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



All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com