View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
[email protected] bgetson@gmail.com is offline
external usenet poster
 
Posts: 23
Default 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