| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Secondary Axis
Yes all information has been selected.
"Andy Pope" wrote: Hi, You sure you have the series selected? You can also right click the series in the chart to get a popup menu to pick Format from. Or just double click the series. Cheers Andy Ann wrote: I need to plot a secondary axis on a chart. MS instructions for plotting secondary series listed below. The problem is there isn't a "Selected Data Series" on the Format menu. I am using XP, how do I get this? When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series. Click the data series you want to plot along a secondary value axis. On the Format menu, click Selected Data Series, and then click the Axis tab. Click Secondary axis. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different Secondary X Axis but same Y Axis | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
| How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Threaded Mode
