+ Reply to Thread
Results 1 to 7 of 7

how to produce this graph

  1. #1
    Registered User
    Join Date
    11-29-2011
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    7

    how to produce this graph

    I would like to know if it is possible to produce graphs like this one(special border effect) using Excel:
    http://goo.gl/aoNlL from this page: http://goo.gl/PsBDe

    If not, which tool should I use?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,333

    Re: how to produce this graph

    Hi aha123 and welcome to the forum,

    The "graph" you want looks a lot like conditional formatting data bars. See:
    http://www.addictivetips.com/microso...010-data-bars/

    I don't see where you need a graph to do what you want.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-29-2011
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: how to produce this graph

    No, sorry I didn't state my question clearly. This graph itself is a screenshot of a Google Analytics chart. I want to know how to create the border effect to the graph: shadow on the right and paper torn apart at the bottom. I put this question in WebDeveloper forum and nobody answered it, so I came to here for help. I guess there must be many graph/chart gurus here.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: how to produce this graph

    Find a picture that looks like you want and use it as the fill picture for the chart.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: how to produce this graph

    The "torn edge" effect comes from a screenshot tool. Most probably SnagIt.

    The chart has not been formatted like this with Excel, but shg's approach would work.

  6. #6
    Registered User
    Join Date
    11-29-2011
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: how to produce this graph

    teylyn, wow, SnagIt is very cool! Do you know any other tools similar to ShagIt?

  7. #7
    Registered User
    Join Date
    11-29-2011
    Location
    CA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: how to produce this graph

    no worries. I found this review covering popular screenshot programs.
    http://screen-capture-software-revie...enreviews.com/

    SnagIt stands out as the #1.

+ 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