As zhollett points out the problem is the auto scaling.
You just need to uncheck the Min and Max values.
You may find using a clustered column chart is easier.
This will also allow you to use the builtin data labels to display both percentages.
And if you want to get really creative
http://www.andypope.info/charts/thermometer.htm
Thanks
This works great, thank you! I don't understand how you set the min and max at 0 and 1, though. How do you specify that on the graph?
Those thermometer templates are beautiful! I was actually trying to make a thermometer, and just drew a circle with the draw functions and layed it over my graph. These are much better, though, so I'm going to try to understand them so I can use them.
Thank you guys SOOOO much for your help!!!
To set the min/max you can either,
double click the Y axis, to display the format dialog. On the Scale tab set Min=0 and Max=1
Or as zhollett described. Select horizontal gridlines and via their format dialog you can also set the Scale properties.
I got it, thanks! It works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks