VBA for Dynamic Chart Data with N/A or Dynamic Range

[jenitak87]

Hi All,

I can define columns and data for required columns and So on for dynamin range
But how do i convert it into complex charts in the excel file under Tab "Chart Data"
Can anyone advise

Sub create_graph()

Dim ws As Excel.Worksheet
Dim x As Range
Dim y As Range

Set ws = ActiveWorkbook.Worksheets("Chart Data")

Set x = ws.Range("B8:B" & ws.Cells(ws.Rows.Count, "B").End(xlUp).Row)
Set y = ws.Range("C8:B" & ws.Cells(ws.Rows.Count, "C").End(xlUp).Row)

ws.Shapes.AddChart.Select
With ActiveChart
.ChartType = xlLine
.SeriesCollection.NewSeries
.SeriesCollection(1).Values = x
End With

End Sub

Now there are 2 questions here

• Can i create a chart where i can ignore blanks and N/A so my data can alight better in Chart
• Can you help me to with additional code to create the image chart - This option is better for me

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

VBA for Dynamic Chart Data with N/A or Dynamic Range

I can define columns and data for required columns and So on for dynamin range But how do i convert it into complex charts in the excel file under Tab "Chart Data" Can anyone advise Sub

stackoverflow.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.