+ Reply to Thread
Results 1 to 2 of 2

Sparkline Column question

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    Sparkline Column question

    Hi, I have a set of data. Lets say 5000, 6000, 7000, 8000, 9000 and 10000. I use the Sparkline Column and select the range. HOwever, the column aint really to scale. I duno y. By right, 5000 column should be 50% the height of 10000 column but this is not the case, i discover that the lowest value in the range always has a very very low height, almost close to zero. This make the overall presentation very inaccurate.

    Anyone can help?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Sparkline Column question

    Seemed like you have discovered a bug in Sparkline!

    One way to overcome this is to add a zero value as the first or last item in your data set: 0, 5000, 6000, 7000 8000, 9000, 10000.

+ 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. Sparkline not appearing
    By STabassum in forum Excel General
    Replies: 0
    Last Post: 03-02-2017, 04:33 AM
  2. Stacked bar as sparkline
    By samot79 in forum Excel General
    Replies: 1
    Last Post: 12-04-2016, 08:05 PM
  3. Sparkline Min-Max range with current value
    By arucard88 in forum Excel General
    Replies: 0
    Last Post: 09-04-2014, 07:59 AM
  4. creating a sparkline using VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-18-2014, 05:10 AM
  5. Sparkline visible as column but not as line
    By Jefftom in forum Excel General
    Replies: 5
    Last Post: 04-22-2013, 10:14 AM
  6. Sparkline XLMarkerStyle
    By goss in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-23-2013, 09:43 PM
  7. sparkline issue with x and y axis
    By nmss18 in forum Excel General
    Replies: 3
    Last Post: 08-18-2011, 11:52 AM

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