Dynamic chart ranges



I have workbook with several sheets that contain x-y data sets. Each
has a single column of x values followed by several columns of y
values. The definition of the x and y is the consistent between sheets
however the number of data points varies from sheet to sheet.

I made a summary sheet using combo boxes that allows a user to look at
one specific data set (based on sheet name), and one specific y
variable (based on column number). The summary sheet lists the
specified variables and plots them on a simple x-y plot.

The issue is that some data sets have 200 rows and some have 10,000.
If I include enough rows to accommodate the larger set, the x-axis on
the plot includes 10,000 values. If I then switch to the set with 200
points the plot still has 10,000 values with 9,800 equal to zero. This
requires the user to manually set the min/max range of the plot to
display the data every time a new set is selected.

Is it possible to set up the sheet so that the x-axis will
automatically adjust and plot only the non-zero values?



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question