ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   adding baseline and goal lines to a column graph (https://www.excelbanter.com/charts-charting-excel/148798-adding-baseline-goal-lines-column-graph.html)

Zb Kornecki

adding baseline and goal lines to a column graph
 
Other than creating a 2nd and 3rd series of repeating numbers, is there a
simple way of adding 2 lines to mark baseline and goal levels on a column
graph?
Thanks
Zb

Andy Pope

adding baseline and goal lines to a column graph
 
Hi,

Another way, although not necessarily simpler, is to use a xy-scatter series
with 2 xy pairs to define start and finish of line.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Zb Kornecki" <zDOTkorneckiATcomcastDOTnet wrote in message
...
Other than creating a 2nd and 3rd series of repeating numbers, is there a
simple way of adding 2 lines to mark baseline and goal levels on a column
graph?
Thanks
Zb




All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com