Hi
I want a dynamic X Axis, that grow or shrinks based on whether or not there are values in a series.
E.G. A column chart which shows the number of students by year. The series changes based on a "Student Type" Drop down.
When "All" students are shown, the years 1990 - 2010 will have data (so this shows on the X avis), but with other selections, there may only be data for the years 2005 - 2010, whhich really should only show the years 2005, 2006, 2007, 2008, 2009 and 2010 on the X axis.
I have no problem adding a "Named rage" which uses offset to choose the series to show, it's just changing the X axis values which I can't work out.
Many thanks
Ronan
I want a dynamic X Axis, that grow or shrinks based on whether or not there are values in a series.
E.G. A column chart which shows the number of students by year. The series changes based on a "Student Type" Drop down.
When "All" students are shown, the years 1990 - 2010 will have data (so this shows on the X avis), but with other selections, there may only be data for the years 2005 - 2010, whhich really should only show the years 2005, 2006, 2007, 2008, 2009 and 2010 on the X axis.
I have no problem adding a "Named rage" which uses offset to choose the series to show, it's just changing the X axis values which I can't work out.
Many thanks
Ronan
