Many grids

Submitted by WayneK on 2026/04/12 11:37

I like to use charts to display info in a spreadsheet format - eg:

Different charts require different column widths, therefore you cannot consolidate your charts in one grid.  Excel has the same issue.

The only solution I see is creating a new grid for each chart.  This will obviously result in many grids (probably 200-300 for my current project).

One poster said he went down the path of "many grids" but abandoned it.  He didn't explain why.

1) Is there a reason to avoid making many grids?
2) Is there an alternative approach to solving the need for varying column widths?

Wayne

Comments

Hi Wayne,

There is no issue in creating hundreds of grids. I'd like to understand what you mean by a "chart" For me, a chart is like a pie chart, bar or X-Y...

In your example, what I see is a "table" with color coded lines

I had two questions:

1) Is there any issue with creating hundreds of grids?  (you've answered that).
2) Is there another approach to this problem that doesn't involve creating a separate grid for each chart?

I asked #2 just to cover my bases and make sure I've looked at all possible solutions.  

I looked at using one grid and loading different column sets for different charts, as needed. 

Also considered using one grid and manually adjusting column widths as needed for different charts.

Both would be impractical.

I'm fine with the "many grids" solution and will go forward with that.  

Wayne

How do I ?