ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Invert bar chart content but not the axes (https://www.excelbanter.com/charts-charting-excel/240123-invert-bar-chart-content-but-not-axes.html)

tom

Invert bar chart content but not the axes
 
Hi,

I have a bar chart where the lower scores are actually a better result.

i want to represent this in a graph by makign the lower scores appear with a
bigger bar and the higher scores with a smaller bar.

I have inverted the Y axis which has leasd to an upside down look to the bar
chart, want i believe i want to do is keep the Y axes thsi way but have the
bars start formt he bottom rather than the top.

Does anyone know of a way to do this?

Tom

Bernard Liengme[_3_]

Invert bar chart content but not the axes
 
Why not plot something like 10 - Score
With some work, you could have two axes : on with 10 - Score the other with
Score and you could hide the first
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Tom" wrote in message
...
Hi,

I have a bar chart where the lower scores are actually a better result.

i want to represent this in a graph by makign the lower scores appear with
a
bigger bar and the higher scores with a smaller bar.

I have inverted the Y axis which has leasd to an upside down look to the
bar
chart, want i believe i want to do is keep the Y axes thsi way but have
the
bars start formt he bottom rather than the top.

Does anyone know of a way to do this?

Tom





All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com