I have produced a pivot table which pulls the data and corresponding data from a main table. But i get the date only on the first row as shown in attached image 1.
I would like it to be the same as image 2 so i can build a line chart of the data
I have attached a cut down copy of the excel sheet. The data is recorded on sheet 1 and the chart is on sheet 3 with pivot table
What i am trying to do is produce a line chart with the dates at the bottom and the Min Direct plotted across the chart
hope this all makes sense
Bookmarks