Podcast from 6/8/9

[dukeofscouts]

This may not be the place to put this, so if any can think of a better place to put this I'll glady move this.

My question is this, why didn't Mr. Jelen use a pivot table? Granted you'd have to use a line graph and set the line to none, and then change the marker. However it would be way easier to add new entries to the chart, and saves all the agrivation of having to select each series manualy.

Screen shots:
PivotTable:
PivotChart:
Raw Data:

Thanks,
D.O.S.

 

[MrExcel]

D.O.S.

This is a cool suggestion! However - the distance along the x-axis from 16 to 61 is not to scale. That is why I went with the XY chart instead.

There are several ways to solve most problems in Excel and if the manager in the original problem doesn't care about the scale along the x-axis, your solution would be great.

Bill

 

[dukeofscouts]

I knew there had to be a reason.

Thanks,
D.O.S.