Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combo chart
can I create a combo chart with one vertical scale on the left for data
series 1 and another different scale on the right veritcal axis for data series 2 ? series 1 ranges from 0-80; series 2 ranges from 0-10 Thanks DW |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combo chart
Yes,
Highlight your data and start the wizard, choose Custom Types and choose Line/Collumn on two axes or Line/Line on two axes. There is a way to do Column/Column on two axes but it requires a trick -- Cheers, Shane Devenshire "Doug W" wrote: can I create a combo chart with one vertical scale on the left for data series 1 and another different scale on the right veritcal axis for data series 2 ? series 1 ranges from 0-80; series 2 ranges from 0-10 Thanks DW |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
combo chart
Here's the trick:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Yes, Highlight your data and start the wizard, choose Custom Types and choose Line/Collumn on two axes or Line/Line on two axes. There is a way to do Column/Column on two axes but it requires a trick -- Cheers, Shane Devenshire "Doug W" wrote: can I create a combo chart with one vertical scale on the left for data series 1 and another different scale on the right veritcal axis for data series 2 ? series 1 ranges from 0-80; series 2 ranges from 0-10 Thanks DW |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
combo chart
thanks Jon!
Doug W. -- DW "Jon Peltier" wrote: Here's the trick: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Yes, Highlight your data and start the wizard, choose Custom Types and choose Line/Collumn on two axes or Line/Line on two axes. There is a way to do Column/Column on two axes but it requires a trick -- Cheers, Shane Devenshire "Doug W" wrote: can I create a combo chart with one vertical scale on the left for data series 1 and another different scale on the right veritcal axis for data series 2 ? series 1 ranges from 0-80; series 2 ranges from 0-10 Thanks DW |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
combo chart
I could have referred you to the first place I am aware of these having been
demonstrated but that was Personal Computer World (England) April 1995 issue, pg 580. And then again in Macworld December 1996 page unknown. And in Excel Expert Solutions copyright 1996 by Que pg, 718-721. -- Cheers, Shane Devenshire "Doug W" wrote: thanks Jon! Doug W. -- DW "Jon Peltier" wrote: Here's the trick: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "ShaneDevenshire" wrote in message ... Yes, Highlight your data and start the wizard, choose Custom Types and choose Line/Collumn on two axes or Line/Line on two axes. There is a way to do Column/Column on two axes but it requires a trick -- Cheers, Shane Devenshire "Doug W" wrote: can I create a combo chart with one vertical scale on the left for data series 1 and another different scale on the right veritcal axis for data series 2 ? series 1 ranges from 0-80; series 2 ranges from 0-10 Thanks DW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get zeros to match in line-bar combo chart on 2 axes | Charts and Charting in Excel | |||
Avoid Printing the Combo Box with the Chart | Charts and Charting in Excel | |||
Can a combo chart plot 4 variables? (3 bars,1 line) | Charts and Charting in Excel | |||
Chart - slect month by Combo box | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel |