How do I put a 0 in my pie graph?
I need 0, 1, 2, 3 and 4 as my secondary value but Excel always changes to 1,
2, 3, 4 and 5. Thanks in advance, Nivek |
How do I put a 0 in my pie graph?
You mean category value? Arrange your data like this:
Name 0 Y1 1 Y2 2 Y3 3 Y4 4 Y5 The blank cell atop the first column tells Excel to treat it as categories. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Nivek wrote: I need 0, 1, 2, 3 and 4 as my secondary value but Excel always changes to 1, 2, 3, 4 and 5. Thanks in advance, Nivek |
How do I put a 0 in my pie graph?
What I had to do was put 0,1,2,3,4 in the Category Name slot after using Y1
Y2 Y3 Y4 and Y5. Thanks Jon, Nivek "Jon Peltier" wrote: You mean category value? Arrange your data like this: Name 0 Y1 1 Y2 2 Y3 3 Y4 4 Y5 The blank cell atop the first column tells Excel to treat it as categories. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Nivek wrote: I need 0, 1, 2, 3 and 4 as my secondary value but Excel always changes to 1, 2, 3, 4 and 5. Thanks in advance, Nivek |
All times are GMT +1. The time now is 01:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com