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?
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
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?
Average | Material | January | January | January | February | February | February |
135.4733 | N548210 | 0 | 0 | 0 | 149.67 | 0 | 0 |
27.78077 | N548212 | 36.33 | 0 | 0 | 36.33 | 0 | 0 |
23.00231 | N548214 | 68.67 | 0 | 0 | 68.67 | 0 | 0 |
37.93385 | N548216 | 40.33 | 0 | 0 | 40.33 | 0 | 0 |
821.4485 | N549340 | 450 | 0 | 0 | 450 | 0 | 0 |
425.2569 | N549342 | 425 | 0 | 0 | 425 | 0 | 0 |
11.99 | N353330 | 12.67 | 0 | 0 | 12.67 | 0 | 0 |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>