+ Reply to Thread
Results 1 to 3 of 3

How do I plot data by drilling down through sheets?

  1. #1
    MooseTrax
    Guest

    How do I plot data by drilling down through sheets?

    I want to plot data down through sheets in stead of within a sheet. Quattro
    Pro allowed me to do this but can't figure how to do it in Excel

  2. #2
    John Mansfield
    Guest

    RE: How do I plot data by drilling down through sheets?

    MooseTrax,

    You can chart non-contiguous ranges within a worksheet but not between
    sheets. Probably the best option is to create linked cells on a "master"
    sheet to your other sheets and then create the chart based on the data on the
    master sheet.

    ----
    Regards,
    John Mansfield
    http://www.pdbook.com

    "MooseTrax" wrote:

    > I want to plot data down through sheets in stead of within a sheet. Quattro
    > Pro allowed me to do this but can't figure how to do it in Excel


  3. #3
    Jon Peltier
    Guest

    Re: How do I plot data by drilling down through sheets?

    This page may help explain how to set up a summary data range:

    http://peltiertech.com/Excel/ChartsH...iffSheets.html

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

    MooseTrax wrote:

    > I want to plot data down through sheets in stead of within a sheet. Quattro
    > Pro allowed me to do this but can't figure how to do it in Excel



+ 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