What if you want a high-level overview of trends in your Excel data? Use Excel Sparklines in-cell charts to quickly see trends without creating a separate chart.
Sparkline are tiny charts that fit in a worksheet cell that graphically show trends in the data. Sparklines are dynamic; if you change data values, the sparklines automatically update. There are three styles of sparklines: line, column and win/loss. In the screenshot below, I used the line and column Sparklines charts to represent monthly sales volume for each of the reps.
For support on using Sparklines, contact me at sharon_daniel@att.net. Need help with Excel - coaching, data analysis and/or training? Contact me at 561-289-9484 to discuss your needs.
Comentários