Results 1 to 3 of 3

Thread: Formula help

  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Formula help

    Hi all,

    I am using Excel 2010.

    Column C is the daily total.
    Column E is the daily difference.
    -
    I like to use D2 as the data entry point to populate the cell in column C, so I can hide
    columns A,C and E and display colunmn E as a chart.


    Thanks,
    Albert
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am afraid I have no idea what you want in D2. Could you elaborate?

    [Note that if you hide column E, you can not use it for the chart, since charts don't display hidden data...]

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    abaas (2011-12-04)

  4. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts
    Hi Steve,
    I wanted to clean-up the worksheet.
    Wanted to use D2 as the cell in which to enter de daily total.
    But if i can't chart hidden data, then it has to stay the way it is.

    Thanks.
    Albert

Posting Permissions

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