# Excel Graph Question **URL:** \ **Category:** Factual Questions\ **Created:** [August 11, 2007, 1:23am UTC](https://boards.straightdope.com/t/excel-graph-question/415211 "2007-08-11T01:23:56Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![50million](https://avatars.discourse-cdn.com/v4/letter/5/9fc348/32.png) [@50million](https://boards.straightdope.com/u/50million)\ **Post date:** [August 11, 2007, 1:23am UTC](https://boards.straightdope.com/t/excel-graph-question/415211/1 "2007-08-11T01:23:56Z")
Can someone tell me how to put the scale of the graph on the right side instead of the left side on an Excel graph? I feel like I’ve looked everywhere for the option, but I haven’t found it. Thanks in advance. ---
**Author:** ![CookingWithGas](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cookingwithgas/32/485_2.png) [@CookingWithGas](https://boards.straightdope.com/u/CookingWithGas)\ **Post date:** [August 11, 2007, 1:36am UTC](https://boards.straightdope.com/t/excel-graph-question/415211/2 "2007-08-11T01:36:16Z")
You can add a second axis on the right side but only when you have more than one series. When you have more than one series, you can click on a series, then on the menu select Format, Selected Data Series, Axis, and select “Plot Series on Secondary Axis.” This option is grayed out if there is only one series. If you set it up with two series then delete the one plotted on the left axis, the remaining one will be shifted to the lft axis and the right axis will go away. In the back of my memory I seem to dimly have an idea that you can rotate the chart to get what you want with a kludge, but I can’t remember how to do it or whether you really can. ---
**Author:** ![CookingWithGas](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cookingwithgas/32/485_2.png) [@CookingWithGas](https://boards.straightdope.com/u/CookingWithGas)\ **Post date:** [August 11, 2007, 1:39am UTC](https://boards.straightdope.com/t/excel-graph-question/415211/3 "2007-08-11T01:39:04Z")
BTW [Ozgrid](http://www.ozgrid.com/forum/forumdisplay.php?f=8) is the best site I have ever seen for Excel and VBA/Excel help. It requires registration but is totally free. ---
**Author:** ![KneadToKnow](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kneadtoknow/32/3999_2.png) [@KneadToKnow](https://boards.straightdope.com/u/KneadToKnow)\ **Post date:** [August 11, 2007, 1:58am UTC](https://boards.straightdope.com/t/excel-graph-question/415211/4 "2007-08-11T01:58:06Z")
You could set up a second series with exactly the same data, and then format the color of the text for the primary axis to be the same color as the background so it disappears. ---
**Author:** ![Hunter\_Hawk](https://avatars.discourse-cdn.com/v4/letter/h/50afbb/32.png) [@Hunter\_Hawk](https://boards.straightdope.com/u/Hunter_Hawk)\ **Post date:** [August 11, 2007, 2:26am UTC](https://boards.straightdope.com/t/excel-graph-question/415211/5 "2007-08-11T02:26:32Z")
Choose to format the x-axis. In the “Scale” settings, there should be a checkbox called something like “Value axis crosses at maximum category”. ---
**Author:** ![50million](https://avatars.discourse-cdn.com/v4/letter/5/9fc348/32.png) [@50million](https://boards.straightdope.com/u/50million)\ **Post date:** [August 11, 2007, 3:31am UTC](https://boards.straightdope.com/t/excel-graph-question/415211/6 "2007-08-11T03:31:03Z")
Thanks everyone. I already had three series in the graph, so picking the one with the lowest value and making a secondary axis worked perfectly. (At first I picked the “middle” of the three series and it then covered the smallest of the series.) Now it’s perfect. Thanks again.