Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Plotting a Chart

Discussion in 'Information Technology' started by Mayank, Jul 28, 2006.

Tags:
  1. Mayank

    Mayank
    Expand Collapse
    Guest

    This is the sample reproduction of a Chart I wish to implement:

    A
    1 1
    2 "Comment: This is an empty cell, no value entered"
    3 2
    4 0
    5 0
    6 "Comment: The formula used is - =IF(SUM(A4,A5) = 0,"", SUM(A4,A5))"
    7 4
    8 3

    Now, in A6 though the result is 'zero' it displays in the cell as empty, but
    when I plot the line graph it shows zero in the plotting area. For A2, the
    value is empty and the graph shows a break in the graph(empty space is not
    plotted through Tools>Options>Chart>Plot Empty Cells as Not plotted). I want
    the same result for the cell A6, that is the graph shows a gap plotted
    whenever the value is zero(only in some cases) and plot the value when its
    not zero.

    To sum up: The graph should plot a gap when the value is zero(not always) or
    empty cell.
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Looks as though you're talking about Excel. This newsgroup is for questions
    about Access, the database product that's part of Office Professional. You'd
    be best off reposting your question to a newsgroup related to Excel.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Mayank" <Mayank@discussions.microsoft.com> wrote in message
    news:72794E75-2171-4EFC-A6E1-44F0A22E5679@microsoft.com...
    > This is the sample reproduction of a Chart I wish to implement:
    >
    > A
    > 1 1
    > 2 "Comment: This is an empty cell, no value entered"
    > 3 2
    > 4 0
    > 5 0
    > 6 "Comment: The formula used is - =IF(SUM(A4,A5) = 0,"",

    SUM(A4,A5))"
    > 7 4
    > 8 3
    >
    > Now, in A6 though the result is 'zero' it displays in the cell as empty,

    but
    > when I plot the line graph it shows zero in the plotting area. For A2, the
    > value is empty and the graph shows a break in the graph(empty space is not
    > plotted through Tools>Options>Chart>Plot Empty Cells as Not plotted). I

    want
    > the same result for the cell A6, that is the graph shows a gap plotted
    > whenever the value is zero(only in some cases) and plot the value when its
    > not zero.
    >
    > To sum up: The graph should plot a gap when the value is zero(not always)

    or
    > empty cell.
     
  4. Mayank

    Mayank
    Expand Collapse
    Guest

    Ya I realized it later, just after I pressed the Send button :( but I have
    reposted it in proper forum. Sorry for that.


    "Douglas J Steele" wrote:

    > Looks as though you're talking about Excel. This newsgroup is for questions
    > about Access, the database product that's part of Office Professional. You'd
    > be best off reposting your question to a newsgroup related to Excel.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Mayank" <Mayank@discussions.microsoft.com> wrote in message
    > news:72794E75-2171-4EFC-A6E1-44F0A22E5679@microsoft.com...
    > > This is the sample reproduction of a Chart I wish to implement:
    > >
    > > A
    > > 1 1
    > > 2 "Comment: This is an empty cell, no value entered"
    > > 3 2
    > > 4 0
    > > 5 0
    > > 6 "Comment: The formula used is - =IF(SUM(A4,A5) = 0,"",

    > SUM(A4,A5))"
    > > 7 4
    > > 8 3
    > >
    > > Now, in A6 though the result is 'zero' it displays in the cell as empty,

    > but
    > > when I plot the line graph it shows zero in the plotting area. For A2, the
    > > value is empty and the graph shows a break in the graph(empty space is not
    > > plotted through Tools>Options>Chart>Plot Empty Cells as Not plotted). I

    > want
    > > the same result for the cell A6, that is the graph shows a gap plotted
    > > whenever the value is zero(only in some cases) and plot the value when its
    > > not zero.
    > >
    > > To sum up: The graph should plot a gap when the value is zero(not always)

    > or
    > > empty cell.

    >
    >
    >
     

Share This Page