Column A is a list of names populated from an array formula. The result of the array formula may yield anywhere from two to twenty names along with the data associated with the names.
Column B is a value
Column C is a value
Chart1 has an X axis of Column A
The Y axis is numeric values
Since Column A can have a wide range of names, how can I make the X axis dynamic so I don't have a total of 20 place holders when there are only 2 or 3 records?
Bookmarks