-
1
- #1
I've sumitted this as a FAQ but since I asked the question here, I thought I would post what I have found.
After spending a lot of time trying to figure a workaround to the Glitches in Access 2000 Charts, I think I have come up with a procedure for making control charts. I believe this process should also work for many of the advanced chart types. First, I must give credit to faq703-5180 for his post. This gave me the basic idea for this process.
Create Your Chart in Report design view
Use the standard bar graph and select 3 field from your query
Ø Don’t do anything except save your report .
Ø Enter into the report in design mode.
Ø Go to print preview.
Ø Go to file / save. (Important must uses File/Save, not the tool bar)
Exit out of the report.
Ø Re-enter the report in design view.
Change Cart Type
Ø Double click then Right click on chart body and select chart type.
Ø Select Custom Chart type Tab.
Ø Select Line- Columns on 2 axis- Bar-graph.
Ø Click OK.
Ø Right click on chart and select properties.
Ø In Properties box select Row Source and delete.
Ø Click next to Row Source to activate SQL query builder.
Ø Select Query
Important-set up query in This order
Ø X-axis Label
Ø Label of Value that your tracking (String)
Ø 1st control Line (1st Y-axis) (Number)
Ø Value that your tracking (Number)
Ø 2nd Control Line 2nd –Y-axis (Number)
My Fields were:
a. Weeks
b. JobType
c. Baseline
d. Sum of JobHr
e. Capacity
Double click then Right click on chart body and select chart Options.
Select title tab
Ø Fill in 1st X with correct field name
Ø Fill in 1st Y with correct Field name
Ø Fill in 2nd X with correct field name
Ø Fill in 2nd Y with correct Field name
Ø Click OK
Now the save process againe
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø re-enter the report in design view
Very Important Repeat Save:
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø Re-enter the report in design view
Double click on chart until chart table appears
Ø The chart currently only shows 1 control line you will need to delete the column that has your 2nd control line.
Ø After you have deleted the column right click and select insert COLUME.
Ø Now retype the 2nd control line name, VERY IMPORTANT, make sure you type the 2nd control line name exactly as it appears in your query.
Now the save process Last time Do Twice
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø re-enter the report in design view
Very Important Repeat Save:
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø Re-enter the report in design view
You should now see the second control line and your ready to go..
After spending a lot of time trying to figure a workaround to the Glitches in Access 2000 Charts, I think I have come up with a procedure for making control charts. I believe this process should also work for many of the advanced chart types. First, I must give credit to faq703-5180 for his post. This gave me the basic idea for this process.
Create Your Chart in Report design view
Use the standard bar graph and select 3 field from your query
Ø Don’t do anything except save your report .
Ø Enter into the report in design mode.
Ø Go to print preview.
Ø Go to file / save. (Important must uses File/Save, not the tool bar)
Exit out of the report.
Ø Re-enter the report in design view.
Change Cart Type
Ø Double click then Right click on chart body and select chart type.
Ø Select Custom Chart type Tab.
Ø Select Line- Columns on 2 axis- Bar-graph.
Ø Click OK.
Ø Right click on chart and select properties.
Ø In Properties box select Row Source and delete.
Ø Click next to Row Source to activate SQL query builder.
Ø Select Query
Important-set up query in This order
Ø X-axis Label
Ø Label of Value that your tracking (String)
Ø 1st control Line (1st Y-axis) (Number)
Ø Value that your tracking (Number)
Ø 2nd Control Line 2nd –Y-axis (Number)
My Fields were:
a. Weeks
b. JobType
c. Baseline
d. Sum of JobHr
e. Capacity
Double click then Right click on chart body and select chart Options.
Select title tab
Ø Fill in 1st X with correct field name
Ø Fill in 1st Y with correct Field name
Ø Fill in 2nd X with correct field name
Ø Fill in 2nd Y with correct Field name
Ø Click OK
Now the save process againe
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø re-enter the report in design view
Very Important Repeat Save:
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø Re-enter the report in design view
Double click on chart until chart table appears
Ø The chart currently only shows 1 control line you will need to delete the column that has your 2nd control line.
Ø After you have deleted the column right click and select insert COLUME.
Ø Now retype the 2nd control line name, VERY IMPORTANT, make sure you type the 2nd control line name exactly as it appears in your query.
Now the save process Last time Do Twice
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø re-enter the report in design view
Very Important Repeat Save:
Ø Go to print preview
Ø Go to file / save
Ø Exit out of the report
Ø Re-enter the report in design view
You should now see the second control line and your ready to go..
