If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
Flip axis or mirror... | lisbeta | Charts and Charting | 2 | January 24th, 2006 01:38 PM |
how to add a second x axis with same Y axis value in one plot | Mike | Charts and Charting | 1 | October 19th, 2005 08:42 AM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |
Two Y axis with different scales for a line chart | vacaut | Charts and Charting | 3 | October 30th, 2003 01:36 PM |