+ Reply to Thread
Results 1 to 5 of 5

Hiding 0 values in line charts

  1. #1
    Teri
    Guest

    Hiding 0 values in line charts

    I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly
    Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has
    data for the weeks-to-date. How can I chart this data on a line graph--
    showing comparison between the two years--and not chart the zero values?

    Thanks!

  2. #2
    Bernard Liengme
    Guest

    Re: Hiding 0 values in line charts

    1) Fill empty cell with =NA(), OR
    2) Click on chart to activate; use Tools|Options->Chart and specify how
    empty cell are to be treated, OR
    c) Use dynamic chart: see the Excel Tips & Tricks page on my website
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Teri" <Teri@discussions.microsoft.com> wrote in message
    news:7E76883E-A068-445D-B4D7-10A59C9DE86F@microsoft.com...
    >I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly
    > Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has
    > data for the weeks-to-date. How can I chart this data on a line graph--
    > showing comparison between the two years--and not chart the zero values?
    >
    > Thanks!




  3. #3
    Teri
    Guest

    Re: Hiding 0 values in line charts

    Thanks for your response! Actually, the cells aren't empty; they contain
    zeroes. Consequently, I wrote an IF statement and they now have N/A in them.

    Teri

    "Bernard Liengme" wrote:

    > 1) Fill empty cell with =NA(), OR
    > 2) Click on chart to activate; use Tools|Options->Chart and specify how
    > empty cell are to be treated, OR
    > c) Use dynamic chart: see the Excel Tips & Tricks page on my website
    > best wishes
    > --
    > Bernard V Liengme
    > www.stfx.ca/people/bliengme
    > remove caps from email
    >
    > "Teri" <Teri@discussions.microsoft.com> wrote in message
    > news:7E76883E-A068-445D-B4D7-10A59C9DE86F@microsoft.com...
    > >I have two columns, one is 2004 Weekly Sales Revenue and one is 2005 Weekly
    > > Sales Revenue. Obviously, 2004 has data for all 52 weeks. 2005 only has
    > > data for the weeks-to-date. How can I chart this data on a line graph--
    > > showing comparison between the two years--and not chart the zero values?
    > >
    > > Thanks!

    >
    >
    >


  4. #4
    Slippery_one
    Guest

    Re: Hiding 0 values in line charts


    "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
    news:uzqjjLGGFHA.2932@TK2MSFTNGP10.phx.gbl...
    > 1) Fill empty cell with =NA(), OR
    > 2) Click on chart to activate; use Tools|Options->Chart and specify
    > how empty cell are to be treated, OR
    > c) Use dynamic chart: see the Excel Tips & Tricks page on my website
    > best wishes
    > --
    > Bernard V Liengme


    Hello Bernard. My case seems to be a little different but related
    maybe. I have a simple chart that tracks thermistor readings at known
    temperatures: x axis = temperature (24 - 60 deg. F) and y axis = K
    Ohms. I put my resistance reading in the cell that corresponds to my
    temperature at the time. My problem is that I want my line chart to
    show cells 22 - 62 and not include cells 1 - 21. Not sure how to do
    this. Can you nudge me in the right direction please?




  5. #5
    Bernard Liengme
    Guest

    Re: Hiding 0 values in line charts

    If I understand the question correctly, all you need do is change the source
    for the chart.
    Click on chart; look at the coloured 'range finder' lines around the cells
    that are use to make the chart; drag the top of these down to the first cell
    to be used.
    Send me the file (my email not the group) if you are unsuccessful
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Slippery_one" <Slippery_one@nospam.net> wrote in message
    news:O%234nbyGGFHA.3888@TK2MSFTNGP12.phx.gbl...
    >
    > "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
    > news:uzqjjLGGFHA.2932@TK2MSFTNGP10.phx.gbl...
    >> 1) Fill empty cell with =NA(), OR
    >> 2) Click on chart to activate; use Tools|Options->Chart and specify how
    >> empty cell are to be treated, OR
    >> c) Use dynamic chart: see the Excel Tips & Tricks page on my website
    >> best wishes
    >> --
    >> Bernard V Liengme

    >
    > Hello Bernard. My case seems to be a little different but related maybe. I
    > have a simple chart that tracks thermistor readings at known
    > temperatures: x axis = temperature (24 - 60 deg. F) and y axis = K Ohms. I
    > put my resistance reading in the cell that corresponds to my temperature
    > at the time. My problem is that I want my line chart to show cells 22 - 62
    > and not include cells 1 - 21. Not sure how to do this. Can you nudge me in
    > the right direction please?
    >
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1