Use buttons in a Chart
 

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

Use buttons in a Chart
 

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

Use buttons in a Chart
 

I forgot this part...

Remove the XXX from my email address.
XX


"Jim Cone" wrote in message ...
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

Use buttons in a Chart
 

Hi Jim,

I would like to receive this sample chart.

Many thanx for the tip.

Wim Nagels
Belgium


"Jim Cone" wrote:

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

Use buttons in a Chart
 

The chart workbook was just sent to you.
Jim Cone


"King Harry"
wrote in message
...
Hi Jim,

I would like to receive this sample chart.
Many thanx for the tip.
Wim Nagels
Belgium