Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=IF(B3<O;nodisplay(graphA);display(graphA))
Hello,
I have a sheet with numbers and graphs. If the number of the cell B3 is lower than zero, I wish that Graph A, do not display. Is it possible to manage this ? What is fonction to use and how can I give a name for my graph. Thanks for any help. Thierry. PS : I have a frensh version of Excel 2002 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
=IF(B3<O;nodisplay(graphA);display(graphA))
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 | |
|
|
Similar Threads | ||||
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 |