how do you hide the 0% marking on the y axis clustered column chart.
Please check the file.
thanks.
how do you hide the 0% marking on the y axis clustered column chart.
Please check the file.
thanks.
Last edited by enialy; 03-18-2012 at 05:38 PM.
Try...right-click on the Y-axis, select format axis (if you dont see this option, you missed the X-axis), and change the min value from auto to 0.1, see if that works for you. Play with it and see what you can do
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Use a custom number format on the cells to suppress zero.
General;;
If you need the numbers in the table then apply the number format to each series data labels.
If you mean the 0% on the actual Y axis then set it's numberformat to
0%;;
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks