Why hasn't MS fixed this yet.....?

When you create horizontal bar charts, they always come in backwards, so to fix it you have to flip the data. Same with Stacked Collumns. Also, if you have paired bars they come in flipped as well! I've worked with Excel 97 through XP, you think they would have fixed this by now!

Sounds like you are looking for a left handed cup!
Bernard
"jmorris" <anonymous@discussions.microsoft.com> wrote in message
news:E9B2A931-D858-4445-8CDC-C3A25071C58B@microsoft.com...
> When you create horizontal bar charts, they always come in backwards, so
to fix it you have to flip the data. Same with Stacked Collumns. Also, if
you have paired bars they come in flipped as well! I've worked with Excel 97
through XP, you think they would have fixed this by now!

"Bernard V Liengme" <bliengme@stfx.TRUENORTHca> wrote in message
news:uxiqeNz7DHA.3420@TK2MSFTNGP11.phx.gbl...
> Sounds like you are looking for a left handed cup!
> Bernard
> "jmorris" <anonymous@discussions.microsoft.com> wrote in message
> news:E9B2A931-D858-4445-8CDC-C3A25071C58B@microsoft.com...
> > When you create horizontal bar charts, they always come in
backwards, so
> to fix it you have to flip the data. Same with Stacked Collumns.
Also, if
> you have paired bars they come in flipped as well! I've worked with
Excel 97
> through XP, you think they would have fixed this by now!

Microsoft sometimes works on a geological time scale: do they have a
left-handed mouse yet?


--
James V. Silverton
Potomac, Maryland, USA

The labels are listed in the order they appear in the worksheet, with
the first label closest to the Y axis. That's the way it has always
been, and although I don't care for this either, I have learned to
adapt. You could always write a macro to change it after the fact, or
make a custom chart type that has the axis order reversed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

jmorris wrote:

> When you create horizontal bar charts, they always come in backwards,
> so to fix it you have to flip the data. Same with Stacked Collumns.
> Also, if you have paired bars they come in flipped as well! I've
> worked with Excel 97 through XP, you think they would have fixed this
> by now!

I use one of their wireless optical mouse-keyboard combinations, with
the mouse usually in my left hand. The mouse is symmetric. One could
reassign the buttons, but after years of sharing a mouse with family
members, I just use it the way it came out of the box.

Yes, they can be very slow to address important issues. It wasn't until
2003 that the statistical functions finally were improved. I wish there
were a NULL() or BLANK() worksheet function, so a formula could really
be treated as a blank cell. Maybe before I retire.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

James Silverton wrote:
> "Bernard V Liengme" <bliengme@stfx.TRUENORTHca> wrote in message
> news:uxiqeNz7DHA.3420@TK2MSFTNGP11.phx.gbl...
>
>>Sounds like you are looking for a left handed cup!
>>Bernard
>>"jmorris" <anonymous@discussions.microsoft.com> wrote in message
>>news:E9B2A931-D858-4445-8CDC-C3A25071C58B@microsoft.com...
>>
>>>When you create horizontal bar charts, they always come in
>
> backwards, so
>
>>to fix it you have to flip the data. Same with Stacked Collumns.
>
> Also, if
>
>>you have paired bars they come in flipped as well! I've worked with
>
> Excel 97
>
>>through XP, you think they would have fixed this by now!
>
>
> Microsoft sometimes works on a geological time scale: do they have a
> left-handed mouse yet?
>
>

I have the converse problem with LINEST. I always think of ordered pairs of
data in the form (x,y) so I would like the syntax to be LINEST(x-values,
y-values...)
Now imagine a world in which we could customize such things. It could be
great until we started to communicate with others!!!!!!
--
Bernard
www.stfx.ca/people/bliengme
remove CAPS in e-mail address

"Jon Peltier" <jonxlmvpNO@SPAMpeltiertech.com> wrote in message
news:O2u$iC07DHA.2676@TK2MSFTNGP10.phx.gbl...
> The labels are listed in the order they appear in the worksheet, with
> the first label closest to the Y axis. That's the way it has always
> been, and although I don't care for this either, I have learned to
> adapt. You could always write a macro to change it after the fact, or
> make a custom chart type that has the axis order reversed.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> jmorris wrote:
>
> > When you create horizontal bar charts, they always come in backwards,
> > so to fix it you have to flip the data. Same with Stacked Collumns.
> > Also, if you have paired bars they come in flipped as well! I've
> > worked with Excel 97 through XP, you think they would have fixed this
> > by now!
>

Maybe that's why we have standards and specs....

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Bernard Liengme wrote:
> I have the converse problem with LINEST. I always think of ordered pairs of
> data in the form (x,y) so I would like the syntax to be LINEST(x-values,
> y-values...)
> Now imagine a world in which we could customize such things. It could be
> great until we started to communicate with others!!!!!!