| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Want to show multiple charts in one position, but determine by Lis
Hello,
Okay, I KNOW this can be done, because I have an example spreadsheet of it right in front of my eyes. I just don't know how to replicate it. I have a spreadsheet that shows a certain chart. Next to the chart is a list box that LISTS other charts. When you click on a different "chart label" in the listbox, the main chart updates to reflect that specific chart. This eliminates having to browse to different excel tabs to see different charts. How do I replicate this? I can provide a screenshot upon request so you know what I'm talking about. Thanks for your help! --Stacey |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Want to show multiple charts in one position, but determine by Lis
Here's a semi-annotated example:
http://peltiertech.com/Excel/Charts/...eDropDown.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "StaceyJ" wrote in message ... Hello, Okay, I KNOW this can be done, because I have an example spreadsheet of it right in front of my eyes. I just don't know how to replicate it. I have a spreadsheet that shows a certain chart. Next to the chart is a list box that LISTS other charts. When you click on a different "chart label" in the listbox, the main chart updates to reflect that specific chart. This eliminates having to browse to different excel tabs to see different charts. How do I replicate this? I can provide a screenshot upon request so you know what I'm talking about. Thanks for your help! --Stacey |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Want to show multiple charts in one position, but determine by
Is there a more detailed example? This didn't really help me recreate it . .
.. I'm not sure how to even create the listbox with the VB values in it. "Jon Peltier" wrote: Here's a semi-annotated example: http://peltiertech.com/Excel/Charts/...eDropDown.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "StaceyJ" wrote in message ... Hello, Okay, I KNOW this can be done, because I have an example spreadsheet of it right in front of my eyes. I just don't know how to replicate it. I have a spreadsheet that shows a certain chart. Next to the chart is a list box that LISTS other charts. When you click on a different "chart label" in the listbox, the main chart updates to reflect that specific chart. This eliminates having to browse to different excel tabs to see different charts. How do I replicate this? I can provide a screenshot upon request so you know what I'm talking about. Thanks for your help! --Stacey |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to apply / position labels for a collection of charts | Charts and Charting in Excel | |||
| Multiple charts in one big chart -- how to rotate to vertical position? | Charts and Charting in Excel | |||
| macro to compare multiple cells to determine value | Excel Worksheet Functions | |||
| Bar charts with negative values and label position | Charts and Charting in Excel | |||
| How to determine which rows contain slected cells in a multiple c. | Excel Worksheet Functions | |||
Linear Mode
