• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

Get creative in Excel using sparklines to show data trends

By admin on April 21, 2016

New in Microsoft® Excel® 2010, and later versions, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. For more impact, a sparkline should always be positioned near its data. Whilst this is not a PivotTable option, it is a great tool to use along with PivotTables.
In our example, we’ll display the monthly data trends for the different branches using a sparkline.
Applies To: Microsoft® Excel® 2010 and 2013.
Note: You are welcome to download the workbook to practice.
Select cell O5 on the sparklines worksheet.
Now select the Insert tab then line under the sparklines group.
Select the data range B5:M5, then select OK.
Right click on column O and adjust the column width to 30, then copy the sparkline to cell O8.
Highlight rows 5:8 and right click on one of the selected rows and change the row height to 60.
Select one of the sparklines under design tab select markers.

You have now created a visual representation of your data. It will be easy to analyze your monthly data using sparklines, helping you identify trends on the spot.
The post Get creative in Excel using sparklines to show data trends appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

An easy way to create a dual chart in Excel, trending with a secondary axis
5 Easy steps to change the periods in your cash flow report to months

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd