Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Switch Axes in Graph
Hi,
I need to switch the X axis categories with the Y axis numerical values in a line graph in Excel, PowerPoint or Word. In other words, I need the words to show up on the left and the numerical values on the bottom. Unfortunately, I cannot use a bar graph. I cannot find a way to do this seemingly simple task in the entire Microsoft Office suite. Does anyone have any solutions? Thanks for your help in advance. Robin |
#2
|
|||
|
|||
Print it and turn the paper sideways?
"Robin" wrote in message ... Hi, I need to switch the X axis categories with the Y axis numerical values in a line graph in Excel, PowerPoint or Word. In other words, I need the words to show up on the left and the numerical values on the bottom. Unfortunately, I cannot use a bar graph. I cannot find a way to do this seemingly simple task in the entire Microsoft Office suite. Does anyone have any solutions? Thanks for your help in advance. Robin |
#3
|
|||
|
|||
LOL. Well, I did try to rotate the graph in PowerPoint, so it would appear
that the axes were switched, but, unfortunately, the graph would not rotate. Even if it did, the graph wouldn't look quite right. Turning the paper sideways is my last resort :-). If you think of anything else, please let me know. Robin "Bob Umlas" wrote: Print it and turn the paper sideways? "Robin" wrote in message ... Hi, I need to switch the X axis categories with the Y axis numerical values in a line graph in Excel, PowerPoint or Word. In other words, I need the words to show up on the left and the numerical values on the bottom. Unfortunately, I cannot use a bar graph. I cannot find a way to do this seemingly simple task in the entire Microsoft Office suite. Does anyone have any solutions? Thanks for your help in advance. Robin |
#4
|
|||
|
|||
Hi,
Stephen Bullen has a an example, check FunChrt2 in the charting examples. http://www.oaltd.co.uk/Excel/Default.htm Jon Peltier also has an example http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy Robin wrote: Hi, I need to switch the X axis categories with the Y axis numerical values in a line graph in Excel, PowerPoint or Word. In other words, I need the words to show up on the left and the numerical values on the bottom. Unfortunately, I cannot use a bar graph. I cannot find a way to do this seemingly simple task in the entire Microsoft Office suite. Does anyone have any solutions? Thanks for your help in advance. Robin -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Thanks for your help! I appreciate it.
Robin "Andy Pope" wrote: Hi, Stephen Bullen has a an example, check FunChrt2 in the charting examples. http://www.oaltd.co.uk/Excel/Default.htm Jon Peltier also has an example http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html Cheers Andy Robin wrote: Hi, I need to switch the X axis categories with the Y axis numerical values in a line graph in Excel, PowerPoint or Word. In other words, I need the words to show up on the left and the numerical values on the bottom. Unfortunately, I cannot use a bar graph. I cannot find a way to do this seemingly simple task in the entire Microsoft Office suite. Does anyone have any solutions? Thanks for your help in advance. Robin -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I plot an XY (scatter) graph with two Y axes? | Charts and Charting in Excel | |||
Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
Bar graph values keep changing | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |