Hi all,
I am new to this forum and I have been researched about if it's possible to create many pivot charts without each being generated from an individual pivot table?
My end goal is to publish a excel dashboard to demonstrate the price change of different material cost over time. The data source is a big table with columns of time, material index category, material indexes and such.
I am wondering if there are better ways to have many charts without pivot table? Will it be possible for the graphs to directly linked with the data table? So that I won't need to deal with storing pivot table properly in different sheets. Also if it's not possible to do that, is there a way to store all the pivot tables into one sheet without overlapping to each other?
Any input is appreciated, thank you!
I am new to this forum and I have been researched about if it's possible to create many pivot charts without each being generated from an individual pivot table?
My end goal is to publish a excel dashboard to demonstrate the price change of different material cost over time. The data source is a big table with columns of time, material index category, material indexes and such.
I am wondering if there are better ways to have many charts without pivot table? Will it be possible for the graphs to directly linked with the data table? So that I won't need to deal with storing pivot table properly in different sheets. Also if it's not possible to do that, is there a way to store all the pivot tables into one sheet without overlapping to each other?
Any input is appreciated, thank you!
