Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph - display Category (X) axis in the vertical position
Hello,
I have a very simple line graph with a category axis and 2 value series. I would like to display it inverted: with the categories along the vertical line, and the series values along the horizontal axis. It looks so simple, but I have been unable to find how to do it. Any ideas? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph - display Category (X) axis in the vertical position
Try making a "dot plot"
http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Idoia" wrote in message ... Hello, I have a very simple line graph with a category axis and 2 value series. I would like to display it inverted: with the categories along the vertical line, and the series values along the horizontal axis. It looks so simple, but I have been unable to find how to do it. Any ideas? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph - display Category (X) axis in the vertical position
Thanks for your response.
Unfortunately, that doesn't really help, I don't mind if it's a dot plot, bar chart or line, I just need to know how to align the category axis vertically, just like in the "bar chart" pictire in the web page you point to. In that web page, this step is explained as: "Change the shape of the chart so it's taller than wide." But I still don't know how. Thanks "Jon Peltier" wrote: Try making a "dot plot" http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Idoia" wrote in message ... Hello, I have a very simple line graph with a category axis and 2 value series. I would like to display it inverted: with the categories along the vertical line, and the series values along the horizontal axis. It looks so simple, but I have been unable to find how to do it. Any ideas? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph - display Category (X) axis in the vertical position
If it's an embedded chart, select the chart, and drag one of its corners to
change its shape. If it's a standalone chart sheet, go to Page Setup, and change the page orientation to Portrait. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Idoia" wrote in message ... Thanks for your response. Unfortunately, that doesn't really help, I don't mind if it's a dot plot, bar chart or line, I just need to know how to align the category axis vertically, just like in the "bar chart" pictire in the web page you point to. In that web page, this step is explained as: "Change the shape of the chart so it's taller than wide." But I still don't know how. Thanks "Jon Peltier" wrote: Try making a "dot plot" http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Idoia" wrote in message ... Hello, I have a very simple line graph with a category axis and 2 value series. I would like to display it inverted: with the categories along the vertical line, and the series values along the horizontal axis. It looks so simple, but I have been unable to find how to do it. Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem adding a vertical line to a graph with months on x-axis | Charts and Charting in Excel | |||
y axis category labels on line graph | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
category axis doesn't display values | Charts and Charting in Excel | |||
Axis display as category | Charts and Charting in Excel |