Connecting Tech Pros Worldwide Forums | Help | Site Map

How to Create a graphic from a querie

eclypz's Avatar
Newbie
 
Join Date: Oct 2007
Location: Porto
Posts: 10
#1: Nov 7 '07
Hi,

I have a query named qryDisperGraphic, that returns: Date / MinVal / MidVal / MaxVal.

I want to make a graphic that include the 3 values in 3 distinct series and the x axis is Date.

I try to do this using the option insert graphic, but it doesn't work :( Any one can help me?
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,214
#2: Nov 8 '07

re: How to Create a graphic from a querie


Quote:

Originally Posted by eclypz

Hi,

I have a query named qryDisperGraphic, that returns: Date / MinVal / MidVal / MaxVal.

I want to make a graphic that include the 3 values in 3 distinct series and the x axis is Date.

I try to do this using the option insert graphic, but it doesn't work :( Any one can help me?

  1. Create a Blank Form or use an existing Form.
  2. Select the Form.
  3. Insert ==> Chart ==> Draw Chart on Form.
  4. From the Dialog Box that appears, select qryDisperseGraphic as that Object which will be used to generate the Chart. Select 'ALL' the Fields to be used as Chart Fields ==> <Next>.
  5. Select Type of Chart ==> <Next>.
  6. In the Chart Wizard Dialog:
    1. Drag-N-Drop the Date Field to the X-Axis box.
    2. Drag-N-Drop the MinVal, MidVal, and MaxVal Fields to the Data box. They will be Summed by default.
    3. Click Preview Chart and make any necessary adjustments ==> <Next>.
  7. Name Chart and select whether or not to display a Legend ==> <Finish>.
Reply