+ Reply to Thread
Results 1 to 3 of 3

Editing Pivot Chart Y axis or Multiple Pivot Charts On the Same Page to Compare Data

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Tucson, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    58

    Editing Pivot Chart Y axis or Multiple Pivot Charts On the Same Page to Compare Data

    Ok guys,

    I finally figured out how to get all my data into one pivot table and create A chart exactly how I envisioned. Unfortunatley the Y values for the various pieces of data are drastically different. For example, I am trying To compare data which ranges between ~0 to ~100 to data points which fall ~500000. This Zooms out the graph to the degree that the smaller data can not be discerned.

    \1

    vs.

    \1

    I believe my two options are having two identical charts on the same worksheet in order to compare, or some how zoom the Y-axis on the points I am trying to compare.

    Remember, this is a pivot Chart, So I dont think Im allowed to touch the source code.

    How would I do either of the above? I am of course open to suggestions if anyone believes there is a better way to do it.

    Thanks In advance!
    Last edited by montego; 08-05-2010 at 12:37 PM.

  2. #2
    Registered User
    Join Date
    06-30-2010
    Location
    Tucson, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: Editing Pivot Chart Y axis or Multiple Pivot Charts On the Same Page to Compare D

    TTT I don't think Im going to be able to edit the axis. Could I put two Pivot Charts On the same sheet? Ill go try right now, let you know

  3. #3
    Registered User
    Join Date
    06-30-2010
    Location
    Tucson, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    58

    Cool Re: Editing Pivot Chart Y axis or Multiple Pivot Charts On the Same Page to Compare D

    Yeah, I ended up Creating two Identical Pivot Sheets, then Creating Charts From Them, And then Right Clicking on the Charts>Location>Insert as object in [new sheet] adding them to their own sheet. So there are two identical sheets right on top of one another.

    Thanks For looking, If anyone thinks they might have a better way, such as a way to overlay the graphs, check out the new thread I started http://www.excelforum.com/excel-gene...le-charts.html
    Last edited by montego; 08-05-2010 at 12:37 PM.

+ 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