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
|
|||
|
|||
Chart - Secondary Y-axis with different values/scale
Have the specific knowledge base instructions.
Instructions state to in the chart, select the data series, then via Format menu, Axis tab, click the secondary axis. I can't seem to select the individual data series. It tends to select all the data series and the Axis tab grays out the secondary axis toggle. I have a simple chart requirement total # projects totals $ value of projects need left axis to scale to # projects need right axis to scale to $ value of projects. these data are divergent and doesn't display well in a single y-axis chart. |
#2
|
|||
|
|||
Chart - Secondary Y-axis with different values/scale
Hi,
Here is another way to select chart elements http://www.andypope.info/tips/tip003.htm If the chart is of a 3d variety then you will not be able to add a secondary axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Calendar Print Views - Month" wrote in message ... Have the specific knowledge base instructions. Instructions state to in the chart, select the data series, then via Format menu, Axis tab, click the secondary axis. I can't seem to select the individual data series. It tends to select all the data series and the Axis tab grays out the secondary axis toggle. I have a simple chart requirement total # projects totals $ value of projects need left axis to scale to # projects need right axis to scale to $ value of projects. these data are divergent and doesn't display well in a single y-axis chart. |
#3
|
|||
|
|||
Chart - Secondary Y-axis with different values/scale
Hi,
If you are having problems selecting you can: 1. On the Chart toolbar, open the first tools drop down (Chart Objects) and pick the series. 2. Alternatively, select anything on the chart and press the arrow keys until you reach the desired object (up, down, left, right cursor keys) 3. If the chart is selected as an object you can't select the series! You can tell if it is selected as an object by noting the selection handles - if the charts selection handles are circles you are in object mode, if they are black squares you are in chart mode. If they are circles, click off the chart and back on. If that doesn't work then display the Drawing Toolbar and turn off the Select Objects tool (the white arrow on the far left. -- Thanks, Shane Devenshire "Calendar Print Views - Month" wrote: Have the specific knowledge base instructions. Instructions state to in the chart, select the data series, then via Format menu, Axis tab, click the secondary axis. I can't seem to select the individual data series. It tends to select all the data series and the Axis tab grays out the secondary axis toggle. I have a simple chart requirement total # projects totals $ value of projects need left axis to scale to # projects need right axis to scale to $ value of projects. these data are divergent and doesn't display well in a single y-axis chart. |
Thread Tools | |
Display Modes | |
|
|