I'm trying to create a graph showing the duration of issue resolution. I believe a bubble chart in excel will show what I want but I can't manage to get it working correctly.
For each date I have a number of days (duration) and a number of issues (magnitude). Most dates have a duration of 1 with a large magnitude, and I want to avoid the outliers dominating the chart.
e.g.
- 1-Feb, 1, 15
- 1-Feb, 2, 10
- 1-Feb, 9, 1
- 2-Feb, 1, 11
- 2-Feb, 2, 14
- 2-Feb, 6, 2
- 2-Feb, 18, 1
etc.
I want the data in this example to give me 2 columns of bubbles.
When I try to get excel to create the chart I can't get the date to appear at on the x axis; I get a count (representing the row of the data) instead, and as each row is a separate column, the values don't line up for the date.
Can this be done in Excel 2007 without using VBA?