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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks