Plotting scatter chart with grouped cells

Hi i have a spreadsheet with 12 columns with a value between 1-10, these are grouped together so i can minimize.i have a button that i click and the function creates the chart and plots the 12 values in a line scatter chart. Everything works fine when the 12 cells are not grouped, but when i group them and try it plots all the data on 1 line.

anyone know how to fix this?

create chart code:

Formula:

Set new_chart = ActiveSheet.ChartObjects.Add(Left:=50, Top:=30, Width:=400, Height:300)                

new_chart.Chart.PlotVisibleOnly = False 

new_chart.Chart.SetSourceData Source:=Range("'" & ActiveSheet.Name & "'" & "!$D$" & i & ":$O$" & i)                

new_chart.Chart.ChartType = xlXYScatterLines 'Set Chart Type

Hi dsalter,

I am not a VBA expert, but perhaps this video and tutorial will help you find your solution.

This works when Hiding rows/columns and I think it works for when you Group rows/columns.

How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and Rows


Steve=True