This UDF is now ready to be integrated in the next release of Sparklines for Excel.
It offers the following features :
- Display of 2 series of XY data (square + round symbols)
- 1 vertical reference line
- 1 horizontal reference line
- 1 grey "normality" area defined by its X and Y limits
- Possibility to use logarithmic scale on X and/or Y axis
- Possibility to modify the color of each serie (not the symbols however)
- Possibility to zoom in the chart
- Possibility to toggle the display of lines and symbols
For the ones interested in early testing, here is a template file.
The original code if from Eric Gundersen, with some adjustments.
Feel free to give me your feedback...