Adding horizontal line to VBA column chart

[the_adam]

Hi all,

I've put together some code linked to a button in my data sheet ("Scores"). When pressed, this creates a bar chart in separate worksheets for each row of data. The code probably doesn't look too tidy, but it works fine The data for the chart is in columns H to BZ, of these H is used for the graph title/worksheet name and all other columns are numbers 0-100

Now, I'd also like to add a target line onto these charts - this would be horizontal but at a different level for each graph so I can't just draw it in, the data for this is stored in column E. I wondered if anyone might be able to give any ideas on whether this is possible, or would it be a better move to create a separate target line graph over the top with a transparent background?

Please Login or Register  to view this content.

Thanks, Adam