Secondary axis help
in [Charts]
|
From: EAB1977 on 21 Dec 2009 09:08 Hi everyone, I am having some difficulty in Excel 2007 Charting. I have a stacked bar chart that I would like to add a horizontal secondary axis on. How do I do this? I'm trying to do what the Help says but there is something that I am not getting. 1. I click on the Chart and select the Format Tab 2. In the Current Selection section, there is a Chart Elements drop down and I select Horizontal (Category) axis. 3. I go to my sheet that has the data for the chart and I select the data range that I want per the instructions. I'm lost after this.
From: teylyn on 26 Dec 2009 03:38 Hi, well, the Help says this, actually: "After you add a secondary vertical axis to a chart, you can also add a secondary horizontal (category) axis, which may be useful in an xy (scatter) chart or bubble chart." So, first you need to add a secondary _vertical_ (Y) axis, by selecting a data series and set it to plot on the secondary Y axis. After that, click on the Layout tab in the Chart Tool, _not_ the Format tab! - then the Axes drop down, where you will now find the commands to display the secondary horizontal axis. hth teylyn EAB1977;592602 Wrote: > Hi everyone, > > I am having some difficulty in Excel 2007 Charting. I have a stacked > bar chart that I would like to add a horizontal secondary axis on. How > do I do this? I'm trying to do what the Help says but there is > something that I am not getting. > > 1. I click on the Chart and select the Format Tab > 2. In the Current Selection section, there is a Chart Elements drop > down and I select Horizontal (Category) axis. > 3. I go to my sheet that has the data for the chart and I select the > data range that I want per the instructions. > > I'm lost after this. -- teylyn Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com) ------------------------------------------------------------------------ teylyn's Profile: 983 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=164191 [url="http://www.thecodecage.com"]Microsoft Office Help[/url]
|
Pages: 1 Prev: Multiple Bar Graphs on one chart Next: How to add another y-axis range into chart? |