I have created a chart that I can use to monitor fuel consupmtion of my new car. I have a chart that shows how many litres of fuel I use over 100kms.
In my data table I have about 30 rows. 3 of those rows are filled in with data and the rest are blank. When I want to display the next row of data, which will be the 4th, I have to go into the "select data source" and change where the chart is reading from. I am trying to find a way to have the entire 30 rows of data selected as the data source with only the rows that have been filled in displaying in the chart.
At the moment when I select the entire column as the data source the chart displays all of the empty cells.
Is there a way I can do this?