| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination
I have a chart that has Percent on Right Vert Axis and Number of events on
Left Vert Axis...I want to change it so Percent is on left vertical axis... I tried starting from scratch...only Percent dat so left axis is percent...then add data row below percent data....and percent vert axis switches to right axis? Any insight is appreciated |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination
Hi,
You can place a series on the secondary axis by double clicking the series and picking Secondary from the Axis tab. If you have 2 series you will need both on the primary axis first in order to set the events series to the secondary. Cheers Andy UsGrant_75 wrote: I have a chart that has Percent on Right Vert Axis and Number of events on Left Vert Axis...I want to change it so Percent is on left vertical axis... I tried starting from scratch...only Percent dat so left axis is percent...then add data row below percent data....and percent vert axis switches to right axis? Any insight is appreciated -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i zero pad when using combination of text and numbers? | New Users to Excel | |||
| How do I create a combination chart and table with different data. | Charts and Charting in Excel | |||
| line-column combination chart, with stacked columns | Charts and Charting in Excel | |||
| Help with Combination function | Excel Worksheet Functions | |||
| Help with Combination Function | Excel Worksheet Functions | |||
Hybrid Mode
