Hi,
I have data regarding how many days it takes to complete certain cases - broken up into small cases and complex cases. The raw data is in the first two files - the table at the bottom left hand corner shows first the number of cases, and the row beneath it shows the percent for that month.
In the two graph tabs, I am looking to represent these numbers. As you can see, the first stacked bar graph looks ok - it shows the breakdown percentage of how many days it took to complete the cases in each month.
The problem is the graph below it - the line graph. Using the same data, each series represents a particular month. As you can see, the graph is quite a "mess" in that it is hard to distinguish the lines. I was thinking a better way to represent this was to make it so you can "toggle" which months you wanted to see on the graph itself. For example, if I wanted to compare Jan vs Feb vs March, I could simply "select" those three lines to look at on the graph.
Is this possible?
Bookmarks