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
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
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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks