offset table and chart

[hanif]

Hello,

I created an offset table as column A reprsents 'Feedstock' and columns B to M are months from Jan to Dec. I need to show data on a chart that automatically add new line when new feedstock inserted hence add the new feedstock to the legend. I am struggled on creating this chart. I have attached the spreadsheet for better understanding.

P.S. this can be done by using Table but in my case I can't use table as data will be inserted and will be deleted into and from the table using vba code and this will becoming a problem if using table.

Any help appreciated.

Thanks

[DBY]

Hello
Perhaps you could summarize your data with a Pivot table and Chart. If you create a dynamic named range for your Pivot data, for example:

Please Login or Register  to view this content.

Any data cut or pasted into A1:M50 would show on the Pivot table/Chart after Refresh.

DBY

[hanif]

Could you show that on the attached file please? I am not quite sure if that would work.

Thanks

Hello
Perhaps you could summarize your data with a Pivot table and Chart. If you create a dynamic named range for your Pivot data, for example:

Please Login or Register  to view this content.

Any data cut or pasted into A1:M50 would show on the Pivot table/Chart after Refresh.

DBY

[DBY]

Hello
Attached is an example file using a dynamic named range as the Pivot source data (Feedstock). After refresh of the Pivot anything in A1:M33 on the 'Chart' tab should appear in the Pivot table/Chart.

[hanif]

Thank you so much,

All sorted now.

Hello
Attached is an example file using a dynamic named range as the Pivot source data (Feedstock). After refresh of the Pivot anything in A1:M33 on the 'Chart' tab should appear in the Pivot table/Chart.

[hanif]

All problems in this post are solved.

Thanks to DBY

[hanif]

All problems in this post are solved.

Thanks to DBY