#1
|
|||
|
|||
Unable to create chart borderline and axis
Dear All. Please guide how to create a borderline for fixed consumption to detect higher and lower usage in monthly basis. Attached spreadsheet..refer to sheet Overall monthly usage and usage by forklift. Regards, Ravin |
#2
|
||||
|
||||
No sheet attached
__________________
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 |
#3
|
|||
|
|||
Resending missing sheet
regards to my earlier request, re sending with sheet attached.
Regards |
#4
|
||||
|
||||
There seems to be a problem with your file. Perhaps post it again?
__________________
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 |
#5
|
|||
|
|||
Resending
Resending the worksheet.
Regards Ravin |
#6
|
|||
|
|||
First of all you should get rid of the circular reference you have in sheet FEB 16 cell A35.
You cannot have a formula referring to the same cell as the formula resides in. And then it is not at all clear to me what you mean by: Please guide how to create a borderline for fixed consumption to detect higher and lower usage in monthly basis. Do you intend to show 12 months for each forklift etc.? |
#7
|
|||
|
|||
Chart Error
Hi Xor,
Yes i am trying to create a 12 months statistic on consumption and 12 months diesel usage for each forklift. The border line i meant was actually the average or a line to indicate whether a forklift has over or under filled from the allowed quantity. Regards Ravin |
#8
|
|||
|
|||
In my opinion this is too much data to have in one single chart.
Maybe the attached can be of some use, I don't know. I have deleted the last sheet in order not to exceed the limit of 500 kb when uploading. |
#9
|
|||
|
|||
Thank you all for your kind advise and assistance.
issue solved. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2 x axis in chart | orajesh | Excel | 1 | 12-17-2015 04:14 AM |
Color one name on a chart axis | angalis428 | PowerPoint | 2 | 08-24-2013 09:32 AM |
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 | sharath_ms | PowerPoint | 0 | 07-08-2013 10:06 PM |
Excel chart with three axis | ubns | Excel | 3 | 05-15-2012 06:25 PM |
Help with secondary axis on chart | Beanster | Excel | 0 | 01-30-2012 02:31 PM |