Hi, Hopefully I've successfully attached an example of how far I've got.
This is formed on an example I found on the 'Net and I've added to in order to make it interactive on both the X and Y axis. I've created a data table, interactive data table with the use of check boxes and an associated basic line chart. The data goes through Jan to June. Currently if I untick Jan then #N/A shows up in the X axis of the chart. What I would like is if I untick Jan, is excludes Jan and the X axis reforms starting with Feb. I thought it might have something to do with the axis type in Axis options, but I've played around in there to no avail.
This is just an example, but as the spreadsheet is developed, I expect there to be many months of data added, and it is likely that only the latest months will need to be plotted on the chart. I don't want a big gap on the left hand side of the chart as these earlier months are unticked.
Many thanks in anticipation.
Ian
Bookmarks