Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does the Y axis invert in charting?
Hi,
In a spreadsheet, I have a list of variables down column A, with information out to the left. When I chart that information in a stacked bar graph (so the variables are on the Y-axis of the graph), Excel inverts the order of the variables. So the variables that were at the bottom of the spreadsheet are now at the top of the chart. Is there anything I can do to fix this, other than reordering my variables in the spreadsheet? Thanks, Nathan |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does the Y axis invert in charting?
Right-click the vertical axis, select Format axis, click on the Scale tab,
then also select the bottom 2 checkboxes: Categories in reverse order and Value (Y) axis crosses at maximum category. Bob Umlas Excel MVP "nathanhutto" wrote: Hi, In a spreadsheet, I have a list of variables down column A, with information out to the left. When I chart that information in a stacked bar graph (so the variables are on the Y-axis of the graph), Excel inverts the order of the variables. So the variables that were at the bottom of the spreadsheet are now at the top of the chart. Is there anything I can do to fix this, other than reordering my variables in the spreadsheet? Thanks, Nathan |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does the Y axis invert in charting?
Thanks Bob, that was perfect!
-Nathan |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does the Y axis invert in charting?
Bob gave you the standard workaround, but you did ask "why". To many people
it makes no sense. The "why" is like this: as you count down the items in column A, imagine them numbered starting with 1. The first item is charted first, the second item after that, etc. So in a stacked chart, A is the bottom of the totem pole, with B on top of A, and so on. In a horizontal bar chart, the categories run from category 1 (the first item in column A) closest to the axis, with item 2 above that, 2 slots from the axis, etc. When you look at it from this standpoint, it makes perfect sense. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "nathanhutto" wrote in message ... Hi, In a spreadsheet, I have a list of variables down column A, with information out to the left. When I chart that information in a stacked bar graph (so the variables are on the Y-axis of the graph), Excel inverts the order of the variables. So the variables that were at the bottom of the spreadsheet are now at the top of the chart. Is there anything I can do to fix this, other than reordering my variables in the spreadsheet? Thanks, Nathan |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does the Y axis invert in charting?
How to do it in 2007?
"Jon Peltier" wrote: Bob gave you the standard workaround, but you did ask "why". To many people it makes no sense. The "why" is like this: as you count down the items in column A, imagine them numbered starting with 1. The first item is charted first, the second item after that, etc. So in a stacked chart, A is the bottom of the totem pole, with B on top of A, and so on. In a horizontal bar chart, the categories run from category 1 (the first item in column A) closest to the axis, with item 2 above that, 2 slots from the axis, etc. When you look at it from this standpoint, it makes perfect sense. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "nathanhutto" wrote in message ... Hi, In a spreadsheet, I have a list of variables down column A, with information out to the left. When I chart that information in a stacked bar graph (so the variables are on the Y-axis of the graph), Excel inverts the order of the variables. So the variables that were at the bottom of the spreadsheet are now at the top of the chart. Is there anything I can do to fix this, other than reordering my variables in the spreadsheet? Thanks, Nathan |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does the Y axis invert in charting?
Right click the axis, and on the first tab of the dialog, check the
appropriate boxes under the axis scale settings. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Feejo" wrote in message ... How to do it in 2007? "Jon Peltier" wrote: Bob gave you the standard workaround, but you did ask "why". To many people it makes no sense. The "why" is like this: as you count down the items in column A, imagine them numbered starting with 1. The first item is charted first, the second item after that, etc. So in a stacked chart, A is the bottom of the totem pole, with B on top of A, and so on. In a horizontal bar chart, the categories run from category 1 (the first item in column A) closest to the axis, with item 2 above that, 2 slots from the axis, etc. When you look at it from this standpoint, it makes perfect sense. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "nathanhutto" wrote in message ... Hi, In a spreadsheet, I have a list of variables down column A, with information out to the left. When I chart that information in a stacked bar graph (so the variables are on the Y-axis of the graph), Excel inverts the order of the variables. So the variables that were at the bottom of the spreadsheet are now at the top of the chart. Is there anything I can do to fix this, other than reordering my variables in the spreadsheet? Thanks, Nathan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charting with a secondary Y axis | Excel Discussion (Misc queries) | |||
Charting in 4 different axis | Charts and Charting in Excel | |||
Pivot Charting x-axis control | Charts and Charting in Excel | |||
Advanced 3-D Charting - Z axis in back | Charts and Charting in Excel | |||
Charting with Two Axis | Charts and Charting in Excel |