Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
if-then statement that checks for existence of series 2
This has been posted to excel.programming
I would like to code an if-then or Case statement that does something like this: If ActiveChart.SeriesCollection(2) doesn’t exist, Then ActiveChart.SeriesCollection.NewSeries.Add ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9" ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10" Else ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9" ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10" The only difference is the NewSeries.Add. What do I substitute for doesn’t exist? 0 (zero) or False? Danz98 |
#2
|
|||
|
|||
If ActiveChart.SeriesCollection.Count = 1 Then
ActiveChart.SeriesCollection.NewSeries End If - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ danz98 wrote: This has been posted to excel.programming I would like to code an if-then or Case statement that does something like this: If ActiveChart.SeriesCollection(2) doesn’t exist, Then ActiveChart.SeriesCollection.NewSeries.Add ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9" ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10" Else ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9" ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10" The only difference is the NewSeries.Add. What do I substitute for doesn’t exist? 0 (zero) or False? Danz98 |
#3
|
|||
|
|||
This code was suggested in the excel.programming newsgroup:
ActiveChart.HasAxis(xlValue) = True '<-- add this line With ActiveChart.Axes(xlValue) .MinimumScale = 0 .MaximumScale = 3 .MinorUnit = 0.1 .MajorUnit = 0.5 .Crosses = xlAutomatic .ReversePlotOrder = False .ScaleType = xlLinear .DisplayUnit = xlNone End With ActiveChart.HasAxis(xlValue) = False '<-- add this line by: okaizawa It worked. It's frustrating that all the different recorded macros did not suggest the code. "danz98" wrote in message news:2YbMe.4317$%K4.2387@trnddc09... This has been posted to excel.programming I would like to code an if-then or Case statement that does something like this: If ActiveChart.SeriesCollection(2) doesn’t exist, Then ActiveChart.SeriesCollection.NewSeries.Add ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9" ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10" Else ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9" ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10" The only difference is the NewSeries.Add. What do I substitute for doesn’t exist? 0 (zero) or False? Danz98 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions |