W
Walshy
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
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