sparkline

So I have I have a list with categories and base o the category that I select a Dynamic Range with subcategories is created with Filter,Unique and Order functions. In the following columns I have the sales from Jan to Dec which is connected to s spark lines. The thing is that not all categories...

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"})

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...

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...

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...

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!

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

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...

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...

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...

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

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...

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...

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")...

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...

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...

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...

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...