Problem with chart


T

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
 
Ad

Advertisements

T

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).
 
P

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.
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart problems 1
Chart Problem 0
Chart Problem 1
Chart problem 5
Chart Problems 0
Problem with chart in a form 3
Pivot Chart Form problem 0
Chart problem in Access 97 1

Top