#1
|
|||
|
|||
Graph average monthly consumption
I purchase electricity at random intervals during the month. I record: date purchased, unit balance on meter at time of purchase, units purchased. How can I show on a graph my monthly consumption? If I use the purchase dates on the X axis, the graph will be distorted! Thanks in advance |
#2
|
||||
|
||||
Perhaps try a Pivot graph ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Graph - Need a second X axis on the Top of Graph | paulzy95 | Excel | 6 | 10-09-2016 12:07 PM |
Average Times on a monthly basis | lynchbro | Excel | 6 | 10-21-2014 08:10 AM |
column clustered bar graph with a line graph as secondary axis | Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
How do I keep graph sizing and location for reuse on a monthly basis | lynchbro | PowerPoint | 0 | 06-09-2014 08:06 AM |
Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |