+ Reply to Thread
Results 1 to 4 of 4

Sparklines on a graph for KPI's

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Sparklines on a graph for KPI's

    All,

    I want to create a sparkline chart, embedded within a color-coded area chart. See below link:

    http://www.ahmadjohari.com/wp-conten...h-Comments.png

    The above link is the output picture, see the next link for the article talking about this and other sparkline uses:

    http://www.ahmadjohari.com/2014/03/1...ed-kpi-charts/

    Any thoughts? It looks like a line chart on top of an area chart...thanks for the input!

    Dom

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Sparklines on a graph for KPI's

    Can you use a regular chart instead of a Sparkline?. You can customized the Plot Area to have a Gradient from Green to Yellow to Red, or you can create an image and use it as the background on the plot area.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Sparklines on a graph for KPI's

    In those examples the sparkline is just a line chart in combination with column chart (to provide shading).

    I don't think it is meaning the sparklines available in excel.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Re: Sparklines on a graph for KPI's

    OK I think I get it...seems like the cart is really 2 charts...one with columns, other with lines/sparklines...I'll give it a shot n see if it works.

    Thx,
    Dom

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Horizontal bar / sparklines?
    By C_Q in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-30-2022, 01:55 AM
  2. Update Sparklines VBA
    By kjaminet22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2013, 11:22 AM
  3. Sparklines in Excel
    By sgriggins3 in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 05:46 PM
  4. Activating Sparklines
    By CarolAnn in forum Excel General
    Replies: 1
    Last Post: 10-06-2011, 04:13 AM
  5. Can't Remove Sparklines Add-In
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-20-2011, 11:22 AM

Tags for this Thread

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