Charts: using a filtered list as a data range

D

DavidS

Hello, I have a column of numbers, which I would like to use as the Y axis
on a chart. I can get 5-15 numbers or rows (in the column) each day and I
have 8 months of data. I would like to filter the column according time or
have a drop down box to select month and change the chart axis to reflect
only that month. The X axis only needs to increment for every Y value. If I
have another column with incrementing numbers for each row for the X axis,
this causes a problem when I want to select only a months data for the
chart. Would appreciate any help or ideas. Thanks very much, David
 

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

Similar Threads

Filtered view of Visio Chart 0
Scatter graphs, excel 11 mac user 0
simple chart 0
Using a filtered list as data range for a chart 0
Setting column width in a table with a macro is not working 0
Generate Equation From The Data 0
Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0

Top