Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot chart is it possible to hide individual field buttons? Layout Field buttons Matt Charts and Charting in Excel 0 August 27th 06 02:57 PM
chart from Pivot chart [email protected] Charts and Charting in Excel 1 August 4th 06 04:51 PM
Selecting part of a series for a chart? Al Charts and Charting in Excel 6 May 16th 06 12:45 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"