+ Reply to Thread
Results 1 to 4 of 4

How can you add the same data series to all charts in a workbook

  1. #1
    MBubier
    Guest

    How can you add the same data series to all charts in a workbook

    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.

  2. #2
    Barb Reinhardt
    Guest

    Re: 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" <[email protected]> wrote in message
    news:[email protected]...
    > 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.




  3. #3
    Jon Peltier
    Guest

    Re: How can you add the same data series to all charts in a workbook

    Try this:

    Plot the series in a new chart. Copy the chart, then select a chart that
    needs the new series, choose Paste Special from the Edit menu, with the
    Formulas option. Select the next chart and repeat the paste special (use the
    F4 key as a shortcut for Repeat Last Action).

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

    "MBubier" <[email protected]> wrote in message
    news:[email protected]...
    > 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.




  4. #4
    MBubier
    Guest

    Re: How can you add the same data series to all charts in a workbo

    This worked!! Thanks!

    "Jon Peltier" wrote:

    > Try this:
    >
    > Plot the series in a new chart. Copy the chart, then select a chart that
    > needs the new series, choose Paste Special from the Edit menu, with the
    > Formulas option. Select the next chart and repeat the paste special (use the
    > F4 key as a shortcut for Repeat Last Action).
    >
    > - Jon
    > -------
    > Jon Peltier, Microsoft Excel MVP
    > Peltier Technical Services
    > Tutorials and Custom Solutions
    > http://PeltierTech.com/
    > _______
    >
    > "MBubier" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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.

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1