Stacked Charts with Vertical Separation

[Barb Reinhardt]

I have created the stacked charts with the separation and am now trying to
put in the chart labels as described in Jon Peltier's instructions

http://peltiertech.com/Excel/Charts/StackedCharts.html

and Paste Special is not an option. I have 5 series of data with 29
observations per series. This has worked for other graphs, just not this
one. I can add the data another way, but want to know why Paste Special
isn't working. Any suggestions?

 

[Jon Peltier]

Barb -

You're pasting the series that define the custom Y axis labels? Are the data ranges
contiguous? Can you add the series through the Source Data dialog (Chart menu),
Series tab?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Barb Reinhardt]

Yes, I'm pasting the series that defines the custom Y axis labels. I added
the data using the source data dialog on the chart menu. My chart data is
in B230 and my label data is in B3758.

I do have quite a few worksheets in this workbook. Could that be part of
the problem?

Your site has been invaluable to me. Thanks for the effort you put into
your it.

Barb Reinhardt

 

[Jon Peltier]

Barb -

You mean Paste Special is grayed out? I can't figure why, unless the workbook has
been compromised. Does it also not work on other charts in that worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______