I have a table of 30 rows which look up different values depending on the their column titles. From this table I have created a graph. When I change the column titles sometimes the data does not fill all 30 rows. Therefore I am left with #N/A where the lookups cannot find a value which leaves an area on the graph with no data.
What I want is the graph to expand / contract to show only the valid data. I have a cell that counts the number of valid cells so thought there might be a way of only returning the number of rows that have been counted. Is this possible??!!
Thanks!
you can use named ranges to specify the series data range.
I have already used named ranges - can't seem to get it to work arg! Perhaps you can give me some more details? Thanks
perhaps you can post the workbook you have
Just tried posting the workbook but is too big - can't take anything else out of it though!
could i email it to u?
andy AT andypope DOT info
After recieving the file I was am to resolve cokee33's problem with the following named ranges.
CHT_LABELS: =OFFSET(REPORT!$C$9,0,0,REPORT!$I$5,1)
CHT_COPD: =OFFSET(CHT_LABELS,0,1)
CHT_ASTHMA: =OFFSET(CHT_LABELS,0,2)
Used in the charts series formula
=SERIES(REPORT!$D$8,'COPD 1copy.xls'!CHT_LABELS,'COPD 1copy.xls'!CHT_COPD,1)
=SERIES(REPORT!$E$8,'COPD 1copy.xls'!CHT_LABELS,'COPD 1copy.xls'!CHT_ASTHMA,2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks