Dynamic Interactive Line Graph

**takeawalkk** · 08-24-2017, 02:34 PM

Hello All,

I'm trying to create a dynamic chart using data validation feature or combine all the data series into one chart but I'm unable too.

In column A I have all the headings I want to use in my legend/data validation and in column Z I have the corresponding values. Can someone advise on how to go about this

Thanks!

**MrShorty** · 08-24-2017, 02:42 PM

It is difficult to give advice on so little information.

My first thought is to use a pivot table/chart if your source data are set up to be a good source for a pivot table. http://www.excel-easy.com/data-analy...ot-tables.html