View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Barb Reinhardt
 
Posts: n/a
Default How can you add the same data series to all charts in a workbook

I'd save your workbook, just in case this doesn't work as I think it should.

You can select the series in the chart that includes the series and copy the
formula for the series. It looks something like

=SERIES(...)
Paste that in each chart you want to add it to.

"MBubier" wrote in message
...
I have numerous charts on separate worksheets in one workbook and would
like
to add the same data series to all the charts. I have tried highlighting
all
the worksheets and adding the series to no avail.