Create a sliding line on a chart

[roscoe]

I'll start by apologizing for my vagueness but I'm working on a proprietary project of which I can't disclose much, but seeking advice for a trick I'd like to try.

I have an XY chart that has time across the X-axis (bottom) and a lot of horizontal lines showing events by start/stop times (staggered vertically). (If you want to envision a Gantt chart you wouldn't be far off).

Sometimes the user needs to plan an event of variable duration and needs to fit it into a suitable time slot. My desire is to offer a button that will insert a horizontal line (duration defined by the user and easily editable) with a scroll bar to slide the line left/right so the user can quickly visualize the best fit.

The dialogue box has several options, only one of which is linkable. How would I use VBA to populate those options (In their infinite wisdom, my IT shop elected to NOT install the VBA help files...#grrrr).

I'd also like to hide the scroll bar until it is "invoked".

Seeking ideas from this esteemed and august group!

Thanks!

 

[James006]

Re: help: Want to create a sliding line on a chart

Hi,

Your best possible source of inspiration ... is Jon Peltier's site ...

https://peltiertech.com/add-horizontal-line-to-excel-chart/

Hope this will help

 

[roscoe]

Re: help: Want to create a sliding line on a chart

Sorry if I wasn't clear. Adding a line is the easy part (I already have many of them via VBA...my primary question is how to use a scroll bar to move one left/right on the chart.

But thanks!

 

[James006]

Re: help: Want to create a sliding line on a chart

Sorry if I read your message way too quickly ...

For a dynamic Vertical Line ...

see https://excelchamps.com/blog/add-a-vertical-line-in-excel-chart/

HTH

 

[roscoe]

Re: help: Want to create a sliding line on a chart

Once again with more clarity

I'm trying to build the line and populate the scroll options via VBA. I can't figure out the calls to do that.