Graph Values

[Michelle]

I have a bar graph with 5 years of data; however, I would
like to show the values for only the last two years.

It there a way to do this?

Thanks.

Michelle

 

[Dave Peterson]

Maybe you could just apply Data|filter|autofilter to your data.

Then show just the dates you want.
Then select the chart and
tools|options|Chart Tab
Make sure that "Plot visible cells only" is checked.

(It was for me by default.)