Make dynamic charts more dynamic

M

Milo

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.
 
A

Andy Pope

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

Dynamic stacked bar chart not working 3
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Mac Excel 2008 - Update while sliding? 0
Can you make a chart's data *always* refer to a dynamic range name? 2
Dynamic Charting But for a Stacked Colum Chart 3
Dynamic stacked bar chart scroll bar 1
Really dynamic monthly chart title 1
Dynamic chart ranges (slight variation) 2

Top