bg18461
12-03-2008, 10:31 AM
Please see attached excel file for example,
I currently have a line (drawing object) which shows the goal line for my bar graph. In the attached file, the goal is 84.99%. This is a variable and I have to manually move the bar as this goal changes. I have multiple graphs and this is very time consuming. I have tried methods found here:
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm
But most of them are for scatter type graphing data, and the methods that are not, just dont seem to work for the chart type I am using. I think my only option is to use vba to move the bar based on a value, please let me know if you can help.
I currently have a line (drawing object) which shows the goal line for my bar graph. In the attached file, the goal is 84.99%. This is a variable and I have to manually move the bar as this goal changes. I have multiple graphs and this is very time consuming. I have tried methods found here:
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm
But most of them are for scatter type graphing data, and the methods that are not, just dont seem to work for the chart type I am using. I think my only option is to use vba to move the bar based on a value, please let me know if you can help.