Hi, I have a tricky chunk of data I want to graph to show trends over time.
The data is organised into values per facility, per category, per month over a 6 month period.
I would like to be able to graph all the data together, but there is just too much information (even using a secondary axis) - the graph is essentially unreadable.
My audience is very visual and a graph is what I need - all suggestions would be welcome!
I'm using Excel 2007.
Thanks in advance...
Perhaps you could use a Dynamic Chart to select which data series to include on the chart with the ability to change what is plotted on the fly.
Interactive Charting by Combo Box or Checkbox
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks