I want to create a bar/line chart with the data presented in the excel sheet( right now it is empty but soon we fill the data). As you see the data is aligned chronologically and I have to represent this data in a bar graph ( I have more than 40 sheets containing the same format. Thus, I can not transform it). The problem here is that I am unable to select all data at ones and in addition to it I have to apply filters on the bases of the fields presented in the first row.
I transform the data and created a bar graph.