Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
hOW DO i FLIP THE X AND Y AXIS
Hi
I am using a line graph with the source data from a table in this format Model 1 Model 2 Model3 Month 1 month 2 month 2 Without changing the format of my table, how do I display on the graph the models as the Legend and the months on the left. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
hOW DO i FLIP THE X AND Y AXIS
Depends on the chart type. If it's a Column chart, change it to a Bar chart
(Chart menu Chart Type). If it's a Line chart, change it to an XY chart. You can only plot numbers on a Y axis. Are the months numeric? If not, either change the data to display dates (full dates, like 1-Jan-2006), or change to display integers like 1, 2, 3, etc. This display can be adjusted using a custom number format, something like "Month "0 (where 0 is a zero character), or you can just leave the numbers and use a Y axis title of Month. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "keen learner" wrote in message ... Hi I am using a line graph with the source data from a table in this format Model 1 Model 2 Model3 Month 1 month 2 month 2 Without changing the format of my table, how do I display on the graph the models as the Legend and the months on the left. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Flip axis or mirror... | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel |