Column Charts in Access

[GeminI3]

I have run into a serious problem. I am fairly new with making charts in
Access. I created a from and designed a table, within the form, by
populating text boxes with query results (counts). I would like to used
these text boxes to populate the column chart...very much the same way in
Excel. I would like to code the chart to use the text boxes as the data
points (series)...How do I accomplish this task?

 

[Greg Collins]

Hi. Your quesiton is best asked in the Excel newsgroup. Thanks.

 

[GeminI3]

The data that I am manipulating is dynamic...It changes every month. I would
like to create a dynamic chart in Access that will change as the data is
changing. I guess my question is, "How do I go about writing VBA code to
control my column graphs?" I know that it can be done, I am just not sure
how. Thanks for responding.

 

[Greg Collins]

I'm sorry -- I misunderstood that your question was about InfoPath/Access...
I thought it was an Excel specific quesiton.

As for your specific question, I don't personally have an answer...

Perhaps someone else can jump in here and answer this question?

 

[GeminI3]

I am quite flexible with what I am trying to accomplish...meaning, if I can
bring in an Excel column chart and use the text boxes as the data series,
then I am all for it. The biggest issue that I am having is when I query my
table and there are no records for that particular count, I am not getting a
zero. Instead I am getting "" as the result. Well this poses a difficult
workaround. I would like to have the results display a zero. This is why I
used the text boxes to do an IIF statement to return zero when there are no
records. If I could do this on the front end (Query) then I could probably
continue writing queries for each data collection and plot my graphs that
way...Please help!!!