Charting Selective Data
Thank you for your help, and sorry for my delay.
Jon, you're right, I want to create a dynamic chart. I've had some
success with that in the past; however, I can't figure out how to get
that to work with this problem.
The formulas themselves are dynamic - they constantly update
themselves for each year and month, but I don't know how to make my
chart dynamic as well. Whenever I try, I usually end up graphing the
#N/A data, which gives me blank values on my chart.
Can you give me some more directed help so that I no longer grab the
#N/A data to chart? I want my x-axis to only include months with real
data.
Thank you again.
-bgetson
|