Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching between two charts based on check / control box
Hi there,
I please need some support on how can I create a check or control box in a spreadsheet which allows to switch between two charts. For instance, checking shows chart A at the specific location in the spreadsheet, unchecking shows chart B at the same location. Many thanks for support. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching between two charts based on check / control box
Place both charts ontop of each other. Then depending on which check box is active move one chart to the from of the other. You can also make one invisible.so the edges don't show. Or even use the opaque setting. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=148186 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching between two charts based on check / control box
using a FORMs checkbox, I have C3 as the linked cell and I set the control to
run this macro: Option Explicit Sub ShowChart() Dim ch1 As ChartObject Dim ch2 As ChartObject Set ch1 = ActiveSheet.ChartObjects("Chart 1") Set ch2 = ActiveSheet.ChartObjects("Chart 2") ch1.Visible = Range("C3") ch2.Visible = Not ch1.Visible End Sub "Hannes" wrote: Hi there, I please need some support on how can I create a check or control box in a spreadsheet which allows to switch between two charts. For instance, checking shows chart A at the specific location in the spreadsheet, unchecking shows chart B at the same location. Many thanks for support. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check or uncheck a check box based on a cell value | Excel Discussion (Misc queries) | |||
How do I add a control check box to control other checkboxes? | Excel Worksheet Functions | |||
Loop through column(s) to check values, perform action based on check | Excel Programming | |||
Check box control | Excel Programming | |||
Excel charts should allow "switching" series on or off | Charts and Charting in Excel |