I made a massive database type thing in excel based on fuel and mileage.
The point is I had thousands of lines to go through and so I set the columns as Date/Number plate/Drivers name/Mileage start/Mileage end/total mileage/litres fuel/cost of fuel
And basically the idea was to make a graph to easily spot any problems with the database (To show up if someone had been getting terrible miles per gallon or someone had been spending more on less fuel etc)
However I am having trouble trying to make a graph to show this in an effective way, Could anyone reccomend to me what I should do?
Question
cammy
Hi guys,
I made a massive database type thing in excel based on fuel and mileage.
The point is I had thousands of lines to go through and so I set the columns as Date/Number plate/Drivers name/Mileage start/Mileage end/total mileage/litres fuel/cost of fuel
And basically the idea was to make a graph to easily spot any problems with the database (To show up if someone had been getting terrible miles per gallon or someone had been spending more on less fuel etc)
However I am having trouble trying to make a graph to show this in an effective way, Could anyone reccomend to me what I should do?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts