Problem with chart

[Tiago Patrício]

Hi again!

When I try to create a chart with chart wizard it always gives me an error
message "Object variable or With block variable not set"

Can anyone tell me what is this??

Thanks

 

[Penguin]

Please post more information. What is the source for the chart?

 

[Tiago Patrício]

First of all thanks for trying to help

The source is a table that has some indicators per year for some companies.

I want to put it in a form that has the company id. (So the chart would be a
kind of subform, only showing data for that company id)

I select the year and values to put in the chart using the chart wizard but
that error always occurs. (The value fields has number format and so does the
year field).

 

[Penguin]

Try creating a query with all of the information from the table. Run
the query to see the results. If all is good then try creating the
chart based on the query.

 

[joshturnbull90]

Hi again!

When I try to create a chart with chart wizard it always gives me an error
message "Object variable or With block variable not set"

Can anyone tell me what is this??

Thanks

For posterity's sake, this appears to be a problem with the way forms are referenced in the background code when the chart object is created. If you are trying to create a chart on a subform while the parent form is open in design view, try closing the parent form, opening the subform by itself and placing the chart on it there.