• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Base Line On Line Graph

M

MikeLanglois

New Member
Good morning all,

Firstly I love the new forum!

I am having a problem with a line graph I am creating. Basically, I am creating a line graph to track costs for certain items. What I need is to be able to create a straight line that will always sit at £10,000 on the line graph.

So if an item goes above this cost, I can easily identify it because it will be above the line.

Other than drawing a line with the line tool (which can be moved) I cant seem to find a way to do it? Can anyone help?

Many thanks
 
Hi Mike ,

One way , which is straightforward , is to use named ranges.

Suppose your data is in a range named Data_Range ; create another named range called Baseline , and define it using the following formula :

=ROW(Data_Range)*0+10000

Now , use this as another series in your chart.

Narayan
 
Thanks very much for your reply Narayank, however when I put this into my spreadsheet, the point only appears on the vertical axis, does not appear across the length of the line graph?
 
MikeLanglois said:
Thanks very much for your reply Narayank, however when I put this into my spreadsheet, the point only appears on the vertical axis, does not appear across the length of the line graph?
Click to expand...
Hi Mike ,

If your data is across columns , in one row , change the definition of the named range Baseline to :

=COLUMN(Data_Range)*0+10000

Narayan
 
Perfect! This is what i was after, that is to place a solid line at a desired point.

My question is (sorry, im new to excel 2010), but in the example sheet above, i cannot find where the'=Example_Mike.xlsx!Baseline' is located? Please help.

Nadim
 
oops!
Sorry for the confusion, the flat horizontal line is fine, but im trying to place a vertical line that shows todays date or a specified date.
 
You must log in or register to reply here.
Back
Top