Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Graph - point on line?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Minneapolis, MN
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to chart 2 types of sales by week. I want the main line to be regular sales, and to have a "point" on the same line when there was a newspaper ad. I have the sales broken down into to rows - row 1 is "total sales" and row 2 is "media sales".

    Can this be done?

    Thanks,
    David

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes. Provide some sample data.

    [ This Message was edited by: Mark W. on 2002-03-19 06:51 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Minneapolis, MN
    Posts
    148
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    WEEK 9 WK 5 10 WK 1 10 WK 2
    total sales 2644 504 1172
    media sales 899 0 191
    reg sales 1745 504 981

    Hope this helps. I f not I can email you a spreadsheet.

    Thanks,
    David

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Okay, so say cells A1:D4 contain...

    {"WEEK","9 WK 5","10 WK 1","10 WK 2"
    ;"total sales",2644,504,1172
    ;"media sales",899,0,191
    ;"reg sales",1745,504,981}

    How do I know when there was a newpaper ad?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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