Chart Help

[Mcook13]

Hello,

I have a sample below of my spreadsheet for data that my customer provides.

I need to create a graph (preferably line graph) to show the trend of information.

We want to be able to switch/filter between the different part numbers so we can see that specific part's history.

I have created a chart (I tried pivot charts too), but I can't make it more presentable and user friendly. Can anyone help?

[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Average[/TD]
[TD="class: xl68, width: 64"]Material[/TD]
[TD="class: xl69, width: 64"]January[/TD]
[TD="class: xl69, width: 64"]January[/TD]
[TD="class: xl69, width: 64"]January[/TD]
[TD="class: xl69, width: 64"]February[/TD]
[TD="class: xl69, width: 64"]February[/TD]
[TD="class: xl69, width: 64"]February[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]135.4733[/TD]
[TD="class: xl65"]N548210[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]149.67[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]27.78077[/TD]
[TD="class: xl65"]N548212[/TD]
[TD="class: xl67, align: right"]36.33[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]36.33[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]23.00231[/TD]
[TD="class: xl65"]N548214[/TD]
[TD="class: xl67, align: right"]68.67[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]68.67[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]37.93385[/TD]
[TD="class: xl65"]N548216[/TD]
[TD="class: xl67, align: right"]40.33[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]40.33[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]821.4485[/TD]
[TD="class: xl65"]N549340[/TD]
[TD="class: xl67, align: right"]450[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]450[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]425.2569[/TD]
[TD="class: xl65"]N549342[/TD]
[TD="class: xl67, align: right"]425[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]425[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]11.99[/TD]
[TD="class: xl65"]N353330[/TD]
[TD="class: xl67, align: right"]12.67[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]12.67[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jon Peltier]

By part number, do you mean material? Because if not there's no part number, so no way to filter.

Do you really have three columns, two filled with only zeros, for each month? Hard to make a good chart with that arrangement.