Use buttons in a Chart

K

King Harry

Hi,

At my job, I received a file with a few charts. One of them contained "data
series", but only one serie could be viewed in a time. To view the next
series, there where some "buttons" to push, and it switches to the next
series.

I find this rather interesting, because in my charts, I use such a lot of
series, that it becomes chaotic sometimes.

Does somebody knows how I can create such buttons? Here at work, nobody can
help me out.

Thanx, Wim
 
J

Jim Cone

Wim,
I have a sample chart in an Excel workbook that displays each
series individually depending on what is selected in a combo box.
Same principle as using buttons. It uses no vba code.
It is pretty crude, but should be self explanatory..
Glad to send it along upon your email request.
Please provide your name and location if you do request it.
--
Jim Cone
San Francisco, USA (my location)
http://www.realezsites.com/bus/primitivesoftware



"King Harry" <King [email protected]>
wrote in message
Hi,
At my job, I received a file with a few charts. One of them contained "data
series", but only one serie could be viewed in a time. To view the next
series, there where some "buttons" to push, and it switches to the next
series.
I find this rather interesting, because in my charts, I use such a lot of
series, that it becomes chaotic sometimes.
Does somebody knows how I can create such buttons? Here at work, nobody can
help me out.
Thanx, Wim
 
J

Jim Cone

I forgot this part...

Remove the XXX from my email address.
[email protected]


Wim,
I have a sample chart in an Excel workbook that displays each
series individually depending on what is selected in a combo box.
Same principle as using buttons. It uses no vba code.
It is pretty crude, but should be self explanatory..
Glad to send it along upon your email request.
Please provide your name and location if you do request it.
 
Top