Plotting Line chart

[krishr11]

Hi,



I want to plot a line chart for following data to see the trend of 'a' -



header1 header2

a 1

v 2

a 4

a 3

c 5

a 9

v 2

a 4



I can put a filter for 'a' and plot the chart. But data keeps adding everyday and I want to know how to update chart automatically whenever it find a new value for 'a'.



Thanks

[Andy Pope]

Here's one way.

You need an extra field that shows either a valid row or very large value.
This is then used to create a list of valid records.

The chart is based on a named range that is determined by valid rows numbers.
The main data table also has a named range to allow the formula to adjust.

See attached.

[krishr1]

Thank you so much!

[krishr1]

quick question:

I need to change the source data for the graph as I add more 'a's. In your graph, source data picks 8 rows. If I change source data to take upto 100th row, since data is only for 8 rows, graph looks 'empty' in most of the chart area as there are no values from 9 to 100 rows.

How do I fix this? I want source data to change as more 'a's are added.

Thanks

[krishr1]

should I enable the macros in the attachment you had sent? What does the macro do here actually?

Also how did you select column C for FILTERDATA. In my actual file, I need to refer different column. How do I do this?

Thanks in advance.

[Andy Pope]

The macro code can be removed. It was for another post I was answering.

There is a named range (Insert > Name > Define) called FILTERDATA which automatic adjusts to the number of records.

You will however need to extend the formula in columns C, E and F to the end of your data set.

The chart also uses a named range so will update automatically.