#Sparklines in excel for mac code#

' - Add ColorRange to Barchart -> each bar can have a specific color - Based on Ramesh code ' - Heatmap, if color code left empty, use background color of 'color' cells from colorscale range ' - Pareto if Label = 1 -> show cumulated % if label=2 -> show individual % ' - StripeChart includes new parameter 'HighlightValue' + 'ShowMedian' by Art Steinmetz ' - Boxplot includes new parameter 'HighlightValue' + 'ShowMedian' by Art Steinmetz ' - LineChart : add Tag =8 and 9 for open or close tag ' - Reactivated Turnmytrappingon in ThisWorkbook module Version 2010 for Excel 2007 / 2010, both add-in and template file, is available for download under the coffe cup -> ' - Added label, tooltip and hyperlink to Heatmap ' - Modified Heatmat so it works w/ merged cells ' - Changed refresh routine -> call procedure DrawCharts ' - Changed Barchart Target behavior (Thicker and smaller tick) ' - Changed scaleXY to scalexy (low caps) as it erased existing formula ' - Modified text size algorithm in Treemap() ' - as default in Xl2007 template file, Sparklines menu will be hidden ' - Assign Ctrl+Alt+F5 & Ctrl+Alt+F6 to display / hide Sparklines menu ' - Piechart : If Val(Application.Version) >= 12, in order to handle properly piecharts in XL2010 (Version = 14) ' - Changed FontSize algorithm in Treemap, to maintain visual hierachy (does not work OK) ' - Added VerticalFlip parameter to LineChart ' - Added Targets to Barchart, possibility to add target value for each bar value ' - Added in StackedChart : If Points.Cells(i).Value = 0 Then TextLabel = '' ' - Corrected call for DrawTarget in BulletChart & RevBulletchart ' - Added control for negative values in BulletChart & RevBulletchart

' - Modified Boxplot so Points can be entered not only as a Range but also as an Array ' - Corrected FunctionWizard behavior for some functions (wrong counting of letters in formula) in SpraklinesSheetActions The Office 2010-64 bits version is now at the same stage as the 32 bits version, including GanttChart.

Sparklines in excel for mac