Difficulty naming the x axis

[Davoucci]

I have a line chart setup in a way where the 4 series are dynamic
named ranges which are in certain columns (B,C,E,F). Rows are dynamic
as the user may add rows. The problem I have is setting the x axis to
a dynamic named range, which is the Month column (A), which may vary
accordingly to user input. I'm looking for a way to get the x axis to
show the values in cells A9to the last row with data).

 

[rvExcelTip]

Rodney Powell at http://www.beyondtechnology.com/geeks021.shtml may b
the answer to your proble

 

[Jon Peltier]

How are you defining the length of the Y ranges in the chart? It's a
dynamic name based on OFFSET and COUNT, right? Make your range for the X
values (or category labels the same way). To get them into the chart,
right click the chart and choose Source Data from the pop up menu.
Select the first series, and in the box that has the existing range for
X values or category labels, change the cell reference to the name of
the range, leaving intact the worksheet name:

change =Sheet1!$A$1:$A$10 to =Sheet1!MyXValues

- Jon