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:

Please Login or Register  to view this content.

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