+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Banned User!
    Join Date
    02-28-2008
    Location
    USA
    MS-Off Ver
    2007
    Posts
    136

    Compare different data in the same chart?

    Hello. Great site

    I'm working with some sales numbers for my department and the total corporation.

    I have 2 columns, one with Sales-department-A with jan09, feb09, mar09. ect
    and a Sales-Corporation also with jan09, feb09, mar09 ect.

    If I want to compare these numbers in a graph.

    Is it possible to make an interactive graph where the user can specify what data the graph should show?
    For example a graph that shows both Jan09 sales from department A and the corporation.
    Or maybe jan09 Department-A sales compared with Department-A jun09 sales?

    So like an interactive graph where you can hide and show the difference charts. Instead of making a hundred charts with all the possible combinations of comparisons?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    Re: Compare different data in the same chart?

    Have a look here at some interactive examples
    http://peltiertech.com/Excel/Charts/Dynamics.html

    You may also want to look at pivot tables/charts
    Cheers
    Andy
    www.andypope.info

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.2.0