Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page