Example files are available to registered members only... Register and login !

Recent Posts

Pages: [1] 2 3 ... 10
1
Thank you Fabrice!


Very nice of you to reply  :)
2
General Discussion / Re: Formulas that produce an array to be used by SFE
« Last post by Fabrice on April 29, 2016, 09:42:14 PM »
By default, the values to be plot have to be passed in the SfE formulas as a Range (like A1:A12).
To pass an array, the VBA code would have to be adapted.


A workaround would be to save your array (resulting from your sumproduct formula) to a named dynamic range (MyDynamicRange for example) and use =barchart(MyDynamicRange).


google "named dynamic range" for examples
3
General Discussion / Formulas that produce an array to be used by SFE
« Last post by kelliottdykes on April 29, 2016, 09:31:49 PM »
Generally when I produce a chart in SFE i reference the actual values (e.g. =barchart(a1:a10)) that will produce the chart.


Is it possible to use a formula to return an array, that will then be used to produce the chart (e.g. =barchart(sumproduct(b1:b10="Thing1",a1:a10))?


I've always gotten an error when I try to insert a formula like the one in red above....but I don't know whether that is because SFE doesn't support using a formula like that....or it doesn't work because I haven't written the formula right (or i don't know the right syntax to use for SFE).


Thanks,


Elliott
4
F.A.Q. about SfE / General Usage
« Last post by jkmaltese on June 29, 2015, 10:19:07 PM »
I'm new to SfE and still trying to figure it out.  I'm running Windows 7 and Excel 2007.  I downloaded the prog (Win 32 version) and it showed up on the Excel tool bar.  I couldn't get it to work in a straight forward manner.  I'm doing line charts and would select the cell, click on the line graph icon, enter the data range in the input drop down box, and nothing happened.  I eventually hit the SfE "Refresh" and it worked.  Then, I shut down Excel and the Computer - went back the next day and the Sparklines Icon was missing from the tool bar.  I downloaded it again, ran it, restarted Excel and it was there.  I'm obviously doing something wrong but cannot figure it out.  Oh- it does not appear as as "add-in" option.  Thanks
5
Bugs, issues / Re: Annoying alert
« Last post by jeanlouis on May 28, 2015, 11:39:17 PM »
Did anyone got a solution to this annoying msgbox?


I use excel 2010 64bits.


Thank you!
6
Suggestions and requests / HBAR() Label
« Last post by Dryburghi on April 20, 2015, 09:20:45 PM »
Fabrice,
Is there a way to add the data label value at the end of the bar?

Thanks
  Iain

7
Hi,
Your request was in fact my first version of BoxPlot, using values calculated separately from the Boxplot function.
Let me find it in my archive an post it on the forum.
However, I this will be a separate UDF, not embeded in SfE....
It will work just the same  8)
I keep you posted.
8
Hi,


I am big fan of sparklines and I´m trying to use the boxplot sparklines in a way like shown in the example: showing a (calibrated across cells) span of values, indicating MIN, MAX and two to be defined values (e.g.: average and own value). This is supposed to be used in customer satisfaction surveys.


Any help on this? As you can read, I´m not an Excel expert and I cannot figure out myself how to use it in this way... :D
koolkidkris
9
Bugs, issues / Re: Annoying alert
« Last post by thequant on December 22, 2014, 10:32:30 PM »
I am experiencing the same issue. Please suggest how to resolve.
10
Bugs, issues / Re: Annoying alert
« Last post by thequant on December 22, 2014, 10:31:36 PM »
I have the same alert. Please advise how to resolve.
Pages: [1] 2 3 ... 10