Results 1 to 9 of 9

Overlaying Pivot Table Charts

Threaded View

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

    Overlaying Pivot Table Charts

    Hello All,

    I have two Identical pivot table Charts inserted as objects in a sheet in my workbook. I would like to overlay the two Charts So that you could select the data to display individually on each pivot chart, and see them both displayed on the same graph with the ranges being somewhat equalized.

    This is because some data ranges between smaller data sets is ~ 0-30, and the data I want to compare it to can be rather large, ~30000-50000. However, relative range of the data sets are similar. Basically I am looking for a quick way to graph two pieces of data in order to observe trends.

    I wish I could post an example with my data, but File size is about 10x larger then max allowed size of 1,000 kb.
    Last edited by montego; 08-05-2010 at 05:53 PM.

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