Chart Help

Mcook13

New Member
Joined
May 14, 2019
Messages
43
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?

AverageMaterialJanuaryJanuaryJanuaryFebruaryFebruaryFebruary
135.4733N548210000149.6700
27.78077N54821236.330036.3300
23.00231N54821468.670068.6700
37.93385N54821640.330040.3300
821.4485N5493404500045000
425.2569N5493424250042500
11.99N35333012.670012.6700

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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.
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top