Make dynamic charts more dynamic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I have a dynamic chart where I show the last 13 values in a spreadsheet
column. I also
implemented a slider bar so that I can go back and have a look at the
previous values if I want.
However, if I now daily update the column of data through an automated
process and the chart
shifts along dynamically, how do I also update the format controls of the
slider bar using VBA automatically,
that is, how do I adjust the maximum value of the format control as soon as
a new value is added to the spreadsheet?

Hope someone can help, thanks you.
Milos.
 
Hi,

Depending on which type of slider you have used this syntax, with
appropriate modifications, should do it.

' Scrollbar from FORMS toolbar
ActiveSheet.Shapes("Scroll Bar 1").ControlFormat.Max = 20

' Scrollbar from CONTROLS TOOLBOX toolbar
ActiveSheet.Shapes("ScrollBar1").OLEFormat.Object.Object.Max = 20

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calendar Control and Dynamic Chart 1
One extra x axis item that wont go away - can anyone help? 3
Dynamic stacked bar chart not working 3
Hiding zeros in dynamic charts 3
Dynamic Area Chart 9
Dynamic Chart 3
Control Charts: "Floating Maximum" 1
Questions on Bar Chart 8

Back
Top