Sparklines ProHow to insert a sparkline in an Excel worksheet?
Prepare your data in Excel
Click on the “Start sparklines pro” button in the BeGraphic ribbon.You may have the following message:
![Image](http://www.begraphic.com/Imgs/Howto/Sparklines_error_message)
If this window appears, check that macros are enabled. To change macros settings, follow the procedure:
1: Click on the “Macro security” button in the BeGraphic ribbon.
![Image](http://www.begraphic.com/Imgs/Howto/Sparklines_macro_security_button)
2: Check if macros are enabled and trust access to the VBA project is checked.
![Image](http://www.begraphic.com/Imgs/Howto/Sparklines_Macro_settings)
3: Restart Excel.
Click on “Insert SFE” and select the type that you are interested in. ![Image](http://www.begraphic.com/Imgs/Howto/Sparklines_Insert_SFE_button)
Set up BeGraphic by filling parameters (e.g.: Points1, Points2…).Tip & tricks: if you drag down a formula containing sparklines, use the “refresh” function.