none
Charting data RRS feed

  • Question

  • Hi,

    I have this data set, and I want to have a bar chart with the columns,

    one column for <3,

    second column for 3-6,

    third column for > 6

    see below.

    Any ideas  how this may be achieved in Access charts? 

    Thanks in advance.

    John


    JG

    Thursday, October 24, 2019 2:11 AM

Answers

  • Hi,

    you could use a query like this as the basis of the chart:

    SELECT IIf([InvLength]<3,[InvLength]) AS [>3 months], IIf([InvLength] Between 3 And 6,[InvLength]) AS [3-6 months], IIf([InvLength]>6,[InvLength]) AS [>6 months]
    FROM MyTable

    or already including the counts:

    SELECT Count(IIf([InvLength]<3,[InvLength])) AS [>3 months], Count(IIf([InvLength] Between 3 And 6,[InvLength])) AS [3-6 months], Count(IIf([InvLength]>6,[InvLength])) AS [>6 months]
    FROM MyTable

    Depending on what kind of chart you use (there are new or old charts) you will have to do some more work but the fitting data should be available now.


    Karl
    http://www.AccessDevCon.com
    http://www.donkarl.com/?AEK


    Thursday, October 24, 2019 11:21 AM

All replies

  • Hi,

    you could use a query like this as the basis of the chart:

    SELECT IIf([InvLength]<3,[InvLength]) AS [>3 months], IIf([InvLength] Between 3 And 6,[InvLength]) AS [3-6 months], IIf([InvLength]>6,[InvLength]) AS [>6 months]
    FROM MyTable

    or already including the counts:

    SELECT Count(IIf([InvLength]<3,[InvLength])) AS [>3 months], Count(IIf([InvLength] Between 3 And 6,[InvLength])) AS [3-6 months], Count(IIf([InvLength]>6,[InvLength])) AS [>6 months]
    FROM MyTable

    Depending on what kind of chart you use (there are new or old charts) you will have to do some more work but the fitting data should be available now.


    Karl
    http://www.AccessDevCon.com
    http://www.donkarl.com/?AEK


    Thursday, October 24, 2019 11:21 AM
  • A thing of beauty .... Thanks Karl D.


    JG

    Friday, October 25, 2019 12:14 AM