sparkline

  1. V

    Negative values in SPARKLINE "charttype","bar"

    I am using sparkline in google sheet specific to charttype as bar if all the values are positive then works fine if I have any negative values then it shows full bar attaching both the screenshot and the formula here =SPARKLINE(P24,{"charttype","bar";"max",max(P24:P25);"color1","#AEB7C0"})
  2. T

    Converting Sparkline from Google Sheets to Excel

    I have a google sheet that uses the sparkline formula '=sparkline(C6:C)' which seems to automatically add to the sparkline with new incoming data in the C column. However, this data range is not valid in Excel when trying to create a sparkline. Does anyone know how to replicate this to have it...
  3. I

    sparkline refresh

    Hi guys i have the data below <tbody> name jan feb march april may jun jack 10 15 17 17 </tbody> I have created a sparkline based on this, I dont have the data for may and june as of yet. Can i set this sparkline up so it automatically updates when may and jun data comes? at the...
  4. T

    Automate sparkline creation (loop help!)

    I have a spreadsheet which consists of two sheets - a summary sheet and a data sheet. On the summary sheet I have a unique list of names that exist in the data sheet in column A, and in the data sheet, there are multiple rows per name (column A) and a number next to each one which denotes...
  5. K

    sparkline with no adjacent range

    Hello - I want to create a sparkline with with no adjacent range I have values in B2, C2 and E2, F2, G2 I have added a name range to these cells but when I tried to plug the values in the sparkline getting error data range not valid. Help? Thanks!
  6. K

    Creating a sparkline using a non-contiguous range

    Hello, trying to put together a sparkline using a a non-contiguous range and getting errors, any ideas on how to achieve this?
  7. B

    Sparklines -'Data source reference not valid'

    Hi, I've never used sparklines before and have been asked to include them in a dashboard. That has a large number of KPIs so I'm trying to create dynamic sparkline that I can create against the first KPI and copy against all other KPIs I've got a formula that will, upon error, show me its...
  8. H

    Sparkline that shows a win loss not based on 0

    Hey, I'm looking to create a sparkline that either allows me to show values above or below a constant or a win/loss where the axis is a constant that isn't zero. Specifically, I'd like to show values that are above the average for the data set and below the average for a data set. Any ideas...
  9. S

    Using Dynamic Ranges with Sparklines

    I thought I finally figured this out using the information here: http://www.mrexcel.com/forum/excel-questions/692415-sparkline-dynamic-range.html, but I can't get the named range to stick as the sparkline range. I'm trying to create sparklines for data in a pivot table that can have a variable...
  10. D

    Sparklines

    Longshot: This is a screen shot of part of a dynamic dashboard. Is there a method, VBA or otherwise for hiding the sparkline if the value in the cell to its left is zero? Many thanks D
  11. K

    Spark line indirect reference error: "Data source reference is not valid"

    Hi, It's my first post here. :) Searched help all over the web but didn't find anything helpful on this, so here we go: I want to create a report with rolling 12 month sparklines. The report is updated monthly and I find it convenient to calculate the range in one cell and then refer to it...
  12. L

    inverting a sparkline

    Hi, I've modelled myself into a cul-de-sac so I'm hoping someone has an easy solution! The data is accounting data, and so credit values are interfaced as negatives, and debits as positives. I'm using sparklines to show the sales and ebitda trends over several years for a number of sites, but...
  13. C

    Updating sparklines with VBA

    Excel 2010 i am attempting to update multiple sparklines with VBA for the first time. First, I recorded a macro and it returned the following usable code: Sub Macro1() Range("D9:G9").Select ActiveCell.SparklineGroups.Item(1).Modify Location:=Range( _ "$D$9,$E$9,$F$9,$G$9")...
  14. N

    Sorting rows with sparklines

    Hi, I have a list of sites with various different metrics and I am compiling a dashboard/summary sheet to make sense of all of the data. I have one line and win/loss sparkline for each site with the source data for each sparkline held in a different sheet. Example data : The source data is...
  15. S

    Make sparklines based on VLOOKUP or Array Index/Match

    Greetings All, I'm looking to create an entire column of sparklines based on month data about items. On Sheet1, I have a list of items and on Sheet 2 I have a list of items in Column A and month quantity for each month in Column B. What I'd like to do, is instead of manually finding the data...
  16. H

    Colouring individual Sparkline data points based on value?

    Hi all, This is a two-parter I guess. Is it possible to set the colour of an individual data point in a sparkline graph? If so, is it possible to set the colour based on criteria, for example above a certain threshold? I'm hoping to use sparks to display how a set of measures are performing...
  17. J

    Referencing data for a chart from a different sheet

    Hi, I have a list of product data summarised in one sheet and detailed data for those products in a second sheet. Next to each product in the first sheet I have a Sparkline describing 12 months performance. The data for the sparkline is in a range called "Actual" in the second sheet. The...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top