I have a chart with numbers ranging from like 80-100, but what's annoying is the bars go from 0-100. How do I change it so it only goes from 80-100 and not 0-100? Otherwise the bars on my chart are unnecessarily long.
I have a chart with numbers ranging from like 80-100, but what's annoying is the bars go from 0-100. How do I change it so it only goes from 80-100 and not 0-100? Otherwise the bars on my chart are unnecessarily long.
Have a look here:
http://office.microsoft.com/en-us/ex...005199141.aspx
or here
http://books.google.ca/books?id=4nJo...page&q&f=false
Last edited by Cutter; 02-10-2011 at 08:16 PM.
column/bar charts that do not come off of a zero datum line can be misleading.
Use non zero datum with caution.
What version of Excel are you using? The first link suggested is a good one if you're using Excel 2003. If you're running Excel 2007, you might try this one instead: http://office.microsoft.com/en-us/ex...163.aspx?CTT=1
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks