Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Charting in report (97/sr2)

    My query/table is basically looking exactly as a chart table in Excel would appear with:

    <table border=1><td>Client ref</td><td>month1</td><td>month2</td><td>month3</td><td>month4</td><td>month5</td><td>month6</td><td>month8</td><td>month9</td><td>month10</td>
    <td>AAA1</td><td>1000</td><td>1200</td><td>1300</td><td>1400</td><td>1500</td><td>1600</td><td>1700</td><td>1800</td><td>1900</td></table>

    It goes on for my list of clients and for each client thirteen months of values

    The field headings are from an accounting package so they are returned as motnh1, month2 etcetera upto month13

    I am trying to get this info as a chart in a report but so far no satisfactory results when using the chart wizard.
    Has anyone else had experience in reporting for the 13 months with many clients.

    TIA
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Charting in report (97/sr2)

    What exactly do you want the chart to display?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Charting in report (97/sr2)

    I need the chart to display
    on the y axis the value scale,
    on the x axis I need it to display the month1;month2;month3 etectera.
    The series will be the client ID's.

    So, where I have say five clients I will have five lines (line chart) and can see month on month the difference in the trade I have with each.

    TIA
    Alan

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Charting in report (97/sr2)

    Let the Chart Wizard create a chart of the type you want. It will probably not be the chart you want, but that doesn't matter.
    Next, set the Row Source property of the chart control to the name of your table/query, then play around with it.

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Charting in report (97/sr2)

    Many thanks Hans, I had a sleep on it and finally got round to resolving the problem.
    Fors starter did as you suggested and left the wizard to create the chart,
    Changed data source to table
    then on double clicking the table I got really frustrated at not being able to change the end presentation to what I wanted.
    Then realised (it was a Homer Doh! moment), change the Data type to "series in rows" on the command bar.
    Voila - jobs a good 'un.

    Thanks for the prompts

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •