Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart numbering
Greetings !
I sought help in here this morning - and help I received ! For which, muchos gracias. But I was wrong - AGAIN ! I had thought that the problem was with numbering the Chart. It wasn't. When running, the procedure ground to a halt, and I deduced what the problem was erroneously. However.... I thought you kight just be interested in what the problem REALLY was - Here's the snatch of code - ..... .SeriesCollection(1).Name = Worksheets ("Comparison").Range("D2").Value <<-- ERROR ! ..... .SeriesCollection(1).XValues = "=Comparison!R9C3:R" & HCEEndRow & "C3" .SeriesCollection(1).Values = "=Comparison!R9C4:R" & HCEEndRow & "C4" ..... The REAL problem was that the Range to be plotted contained #REF! and for SOME reason, "it" wouldn't accept the line where the error occurred. So I have swapped that line and put it AFTER the "Range" lines - Voila ! Pas de problem.... Thanks again, guys, for your help. Regards Robin RClay AT haswell DOT com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbering Data Points on Chart | Charts and Charting in Excel | |||
Row Numbering | Excel Discussion (Misc queries) | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
Page & Chart Numbering | Excel Worksheet Functions | |||
numbering add-in | Excel Discussion (Misc queries) |