| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart 2 axis
Hi, I want to be able to put three different series in a chart. One one a
target value, one a revenue value and the other a percentage. I can see that excel has a Line - Column on 2 axes, however, I would like two on a line and one on a column. Is there anyway I can change this? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart 2 axis
Select the series for which you wish to change the chart type, right-click,
select "Chart Type ...", select the relevant option. -- David Biddulph "Dave" wrote in message ... Hi, I want to be able to put three different series in a chart. One one a target value, one a revenue value and the other a percentage. I can see that excel has a Line - Column on 2 axes, however, I would like two on a line and one on a column. Is there anyway I can change this? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart 2 axis
Thanks
That works perfectly! "David Biddulph" wrote: Select the series for which you wish to change the chart type, right-click, select "Chart Type ...", select the relevant option. -- David Biddulph "Dave" wrote in message ... Hi, I want to be able to put three different series in a chart. One one a target value, one a revenue value and the other a percentage. I can see that excel has a Line - Column on 2 axes, however, I would like two on a line and one on a column. Is there anyway I can change this? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
| TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Linear Mode
