Self-expanding chart (adding more series to the x axis)
Hi all,

I have come across a problem where I need to create a chart that expands vertically and horizontally to new series that are added by a user.

I am trying to achieve this using a 100% stacked 3d chart in excel 2010.

The x axis series and located in column A, ie series 1 = A2, series 2 = A3, series 3 = A4

The y axis series components are located in row 1, ie series 1 = B1, series 2 = C1, series 3 = D1

I am able to arrange the named ranges and series so that the chart automatically includes new series as they are added into column A, however I cannot seem to work out how to automatically include a 4th or 5th series in the y axis when added into cells E1 or F1.

Is there any way to achieve this?

Thanks for the help in advance