Dynamic chart beginning of FY thru current month

[Gman]

Hello –

Hoping someone can help with this I will attach the charts I am trying to make and the data set. I need to figure out how to chart, for the current fiscal year, the beginning thru current month. For example the current month is May so I would need the chart to show Jul 15 – May 16, and update with each month. The reason I cannot chart the entire field and leave June and July blank are because data already populated because of prepaids and other items that are already booked. Not sure if I can do it based on the number of columns? For example current month is 10 so chart 10 columns?


Let me know if you have any ideas. Thank you for any help.

 

[Nebu]

Hi:

You may want to go through the following link
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

Thanks

 

[Gman]

Thank you for pointing me in the right direction Nebu. I was able to figure it out. First you need to use the name manger to name your ranges. If you open the attachment and go under formulas click name manager and you will be able to see how I did it. the ones I made are GRPYValues, OEYValues, OIYValues, RDYValues, XValues. Then on the chart click select data and for the series values use whichever corresponding named range you are after. see attached, hopefully it will help you.