| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with dynamic charts
Im trying to use a dymanic chart and I am using an If then formula for the
data. My false data = "". I thought this was equal to a blank cell but for some reason the dynamic chart is picking it up as something and graphing these blank cells. If I delete the cells the dynamic chart works perfectly. Please advise as to what I need to replace the "" with in order to make the chart work. -Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with dynamic charts
=offset(Sheet1!$A$1,0,0,Count(Sheet1!A:A),1)
Count won't count "" -- Regards, Tom Ogilvy "Ribeye" wrote: Im trying to use a dymanic chart and I am using an If then formula for the data. My false data = "". I thought this was equal to a blank cell but for some reason the dynamic chart is picking it up as something and graphing these blank cells. If I delete the cells the dynamic chart works perfectly. Please advise as to what I need to replace the "" with in order to make the chart work. -Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with dynamic charts
That did it. Thanks a lot....
"Tom Ogilvy" wrote: =offset(Sheet1!$A$1,0,0,Count(Sheet1!A:A),1) Count won't count "" -- Regards, Tom Ogilvy "Ribeye" wrote: Im trying to use a dymanic chart and I am using an If then formula for the data. My false data = "". I thought this was equal to a blank cell but for some reason the dynamic chart is picking it up as something and graphing these blank cells. If I delete the cells the dynamic chart works perfectly. Please advise as to what I need to replace the "" with in order to make the chart work. -Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic charts - problem with copy | Charts and Charting in Excel | |||
| dynamic charts problem | Excel Discussion (Misc queries) | |||
| Dynamic Charts Problem | Charts and Charting in Excel | |||
| Make dynamic charts more dynamic | Charts and Charting in Excel | |||
| Dynamic Charts | Charts and Charting in Excel | |||
Hybrid Mode
