Skip to content
Skip to content
Menu
Alchemex
  • 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
Alchemex

How to create a step chart in Excel

By admin on March 13, 2019April 19, 2019

A step chart shows changes that occur over irregular intervals. For example, it can show stock movement changes, interest rates, etc. A step chart is the perfect alternative to a line chart as it displays the trend as well as the time taken between changes.

The difference between a Step Chart and Line Chart:

A line chart connects data points and the focus in such charts is the trend and not the exact time of change.
On the other hand, a step chart shows the exact time of change in the data as well as the trend. With a step chart, you can easily identify the exact time where there was no change or compare the extent of change at each instance. In this tip, we will show you how to establish the trend of a stock item.

Note: Download the sample workbook to practice this exercise

Steps to create the Step Chart:

1. The data needs to be reconstructed and set up as follows:

  • Copy and paste the headings into new cells.

  • From your dataset, copy the dates starting from the second date and paste in the blank “Date” column.

  • From your dataset, copy your sales values starting at the first value to the second last value, then paste this in the blank “Stock Movement” column.

  • Copy your original data table and paste it directly underneath the data you have just copied over into your new columns.

2. Using this new dataset, select > Insert > Charts > Line Chart. Your Step Chart has been created and is ready for any formatting required.

 

The post How to create a step chart in Excel appeared first on Sage Intelligence.

Source: Excel on Steroids

Post navigation

Create your own reports and customize the way you view your data with Sage Intelligence
How to create and view your Management Packs in Sage 50cloud Intelligence

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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
©2025 Alchemex | WordPress Theme by SuperbThemes.com