Target Line

Hi there I am doing some charts for performance on a
monthly/weekly basis...

The problem I am having is adding a target line on a
chart. Previous I have done this manually by adding a
dotted line and moving it to the desired target. I have
now automated the charts so the month/week adds in each
time the data is added... this changes the size of the
chart thus the target line need setting again... Is there
anyway that I can automatically put a target line in as
this will not change and I wish it to be fixed. Say for
example scale = 1-10 target = 5 on the gridline for 5 make
this one line dotted & bold or Change colour... or
something like this ?

Thank you

Jon Peltier has instructions for adding lines to a chart:

http://www.peltiertech.com/Excel/Cha...s.html#AddLine

Walshy wrote:
Hi there I am doing some charts for performance on a
monthly/weekly basis...

The problem I am having is adding a target line on a
chart. Previous I have done this manually by adding a
dotted line and moving it to the desired target. I have
now automated the charts so the month/week adds in each
time the data is added... this changes the size of the
chart thus the target line need setting again... Is there
anyway that I can automatically put a target line in as
this will not change and I wish it to be fixed. Say for
example scale = 1-10 target = 5 on the gridline for 5 make
this one line dotted & bold or Change colour... or
something like this ?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi,

Have a look at these examples

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Walshy wrote:

Hi there I am doing some charts for performance on a
monthly/weekly basis...

The problem I am having is adding a target line on a
chart. Previous I have done this manually by adding a
dotted line and moving it to the desired target. I have
now automated the charts so the month/week adds in each
time the data is added... this changes the size of the
chart thus the target line need setting again... Is there
anyway that I can automatically put a target line in as
this will not change and I wish it to be fixed. Say for
example scale = 1-10 target = 5 on the gridline for 5 make
this one line dotted & bold or Change colour... or
something like this ?

Thank you

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info