Graph question

[tomleitch]

Hi,

Totally new to making graphs in excel - wondering if anyone can help.

I want to make a line chart with multiple lines and with date value on the X axis.

So I have sheet1 - range z2:z5001 as dates. (this is a list of dates that is dynamically added to - what I want to use is any dates on this column that are within the current calendar year to be added to the graph x axis)..... they have corresponding Y data in colummn AA, AB, AC and AD.

Not sure if this is possible or how to go about it so any help would be very greatly appreciated.


Thanks
Tom

 

[NdNoviceHlp]

You need to extract the data your interested in (x dates and corresponding Y values (AA etc.) ) and move them to a new area then chart the new area. HTH. Dave

 

[tomleitch]

Thanks Dave, think thats a good steer in the right direction - much appreciated

 

[NdNoviceHlp]

You are welcome. Post back if you need further assistance. Dave