Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
First, you can manually name a chart by:
1)Select a cell on the same sheet as the chart 2)Hold the [Ctrl] key and select the chart The name box in the upper left will display the current chart name (Chart1, etc). 3)In that name box, type the new name for the chart (example: myChart). Next, hiding the chart if Cell B3 is less than zero: Try this code: Private Sub Worksheet_Change(ByVal Target As Range) If Range("B3") < 0 Then ActiveSheet.ChartObjects("myChart").Visible = False Else ActiveSheet.ChartObjects("myChart").Visible = True End If End Sub Does that help? Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cells display as R5C5. How do I change it to display E5? | Excel Discussion (Misc queries) | |||
some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel |