Stacked chart problems

[Brad]

I'm using 2007

Using Jon Peltier information found below I'm stuck.

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

I have arranged the data as necessary for the stacking (rahter than three I
have seven). I need to change the axis labels. However, I'm stuck because
the directions state to Paste Special the data as a new series (and I can't
paste special in 2007) and also confused how to to move series information to
secondary axis. Any help would be appreciated.

Thanks in advance.

 

[Jon Peltier]

Paste Special works the same in 2007 if you can find it. Click on the down
arrow on the big ugly Paste button on the home tab.

To change the axis a series is on, select the series, press Ctrl+1 (numeral
one) to bring up the format series dialog, and on the first tab, if you can
call it a tab, select Secondary.

If you lose your horizontal axes, as did an Excel 2007 user who posted a
comment today to the related blog entry, use the Axes control on the Chart
Tools > Layout tab (I think it's Layout, anyway it's the one in the middle).

- Jon

 

[Shane Devenshire]

Hi,

Right-click a series on the chart and choose Format Data Series, and on the
Series Options tab select Secondary Axis

 

[Shane Devenshire]

Hi,

Regarding Paste Special, instead in 2007 select the data in the sheet and
click copy. Right-click the Chart Area and choose Paste. However, if that
doesn't give you what you need, click the Chart Area and choose Home tab,
Paste, Paste Special.

 

[Brad]

That worked and I'm beginning to understand - now I'm stuck at Format the
scale of the secondary category axis so that the value axis does not cross
between categories. Not sure what I need to change

 

[Brad]

Got it Positiion Axis on tick marks

 

[Jon Peltier]

Yep, replace one obscure phrase that most users know with another obscure
phrase that nobody knows.

- Jon