Tech Story

Menu
  • Home
  • Programing
    • Delphi
      • Database
    • Arduino
    • Android
    • Unix Socket
    • Database
  • Network
    • Mikrotik
  • Computer
  • software
    • File Recovery
    • Driver software
    • backup
    • download
    • Drivers
    • format converter
    • programing tools
    • internet
    • phone apps
    • Network
    • graphics
    • professional
    • DISK AND PARTITION
    • OPTIMIZER
    • utility
    • programming tools
    • Games
      • android games
      • computer games
      • ps4
  • Digital Coin
    • Bitcoin
    • Blockchain
  • Privacy Policy
  • contact us
  • news
  • Series and Movies
  • YouTube watch
  • Blog
    • Computer
    • Network
    • General
    • Health and Fitness
    • Management skills
    • Monuments
    • electrical and electronics
Home
general
Advanced Excel – Step Chart
general

Advanced Excel – Step Chart

October 14, 2020

Step chart is helpful if you need to show the info that adjustments at irregular intervals and stays fixed between the adjustments. For instance, Step chart can be utilized to point out the value adjustments of commodities, adjustments in tax charges, adjustments in rates of interest, and so on.

Table of Contents

  • What’s a Step Chart?
  • Variations between Line Charts and Step Charts
  • Benefits of Step Charts
  • Preparation of Knowledge
  • Making a Step Chart

What’s a Step Chart?

A Step chart is a Line chart that doesn’t use the shortest distance to attach two knowledge factors. As an alternative, it makes use of vertical and horizontal strains to attach the info factors in a collection forming a step-like development. The vertical elements of a Step chart denote adjustments within the knowledge and their magnitude. The horizontal elements of a Step chart denote the fidelity of the info.

Contemplate the next knowledge −

What is Step Chart

As you possibly can observe, the info adjustments are occurring at irregular intervals.

A Step chart seems to be as proven beneath.

Step Chart

As you possibly can see, the info adjustments are occurring at irregular intervals. When the info stays fixed, it’s depicted by a horizontal Line, until a change happens. When a change happens, its magnitude is depicted by a vertical Line.

When you had displayed the identical knowledge with a Line chart, it could be like as proven beneath.

Same Data as Line Chart

Variations between Line Charts and Step Charts

You may determine the next variations between a Line chart and a Step chart for a similar knowledge −

  • The main focus of the Line chart is on the development of the info factors and never the precise time of the change. A Step chart exhibits the precise time of the change within the knowledge together with the development.

Exact Time Differences

  • A Line chart can’t depict the magnitude of the change however a Step chart visually depicts the magnitude of the change.

Magnitude Differences

  • Line chart can’t present the period for which there isn’t a change in an information worth. A Step chart can clearly present the period for which there isn’t a change in an information worth.

Duration Differences

  • A Line chart can typically be misleading in displaying the development between two knowledge values. For instance, Line chart can present a change between two values, whereas it’s not the case. Alternatively, a step chart can clearly show the stableness when there are not any adjustments.

Two Values Change

  • A Line chart can show a sudden enhance/lower, although the adjustments happen solely on two events. A Step chart can show solely the 2 occurred adjustments and when the adjustments really occurred.

Display Differences

Benefits of Step Charts

Step charts are helpful to painting any sort of knowledge that has an innate nature of knowledge adjustments at irregular intervals of time. Examples embody the next −

  • Rates of interest vs. time.
  • Tax charges vs. earnings.
  • Electrical energy costs slabs based mostly on the Models utilized.

Preparation of Knowledge

Contemplate the next knowledge −

Preparing Step Chart Data

Step 1 − Choose the info. Copy and paste the info beneath the final row of the info.

Copy Paste Data

Step 2 − Copy and paste your complete knowledge on the appropriate aspect of the info. The info seems to be as given beneath.

Copy Paste Entire Data

Step 3 − Delete the cells highlighted in purple which might be depicted within the desk of second set of knowledge given beneath.

Delete Cells Highlighted in Red

Step 4 − Shift the cells up whereas deleting. The second set of knowledge seems to be as given beneath.

Shift Cells Up

Step 5 − Copy the second set of knowledge and paste it to the appropriate aspect of it to get the third set of knowledge.

Step 6 − Choose the third set of knowledge. Kind it from the smallest to the most important values.

Select Third Set

You have to use this sorted third set of knowledge to create the Step chart.

Making a Step Chart

Comply with the steps given beneath to create a step chart −

Step 1 − Choose the third set of knowledge and insert a Line chart.

Insert Line Chart

Step 2 − Format the chart as follows −

  • Click on on the chart.
  • Click on the DESIGN tab on the Ribbon.
  • Click on Choose Knowledge within the Knowledge group. The Choose Knowledge Supply dialog field seems.
  • Choose Series1 beneath Legend Entries (Collection).
  • Click on the Take away button.
  • Click on the Edit button beneath Horizontal (Class) Axis Labels. Click on OK.

Format Chart

The Axis Labels dialog field seems.

Step 3 − Choose the cells F2:F10 beneath the Axis labels vary and click on OK.

Select Cells

Step 4 − Click on OK within the Choose Knowledge Supply dialog field. Your chart will look as proven beneath.

Select Data Source

Step 5 − As you possibly can observe, some values (Years) within the Horizontal (Class) Axis are lacking. To insert the values, comply with the steps given beneath.

  • Proper click on on the Horizontal Axis.
  • Choose Format Axis.
  • Click on AXIS OPTIONS within the Format Axis pane.
  • Choose Date Axis beneath Axis Sort in AXIS OPTIONS.

Values are Missing in Horizontal Axis

As you possibly can see, the Horizontal (Class) Axis now incorporates even the lacking Years within the Class values. Additional, till a change happens, the road is horizontal. When there’s a change, its magnitude is depicted by the peak of the vertical line.

Step 6 − Deselect the Chart Title and Legend in Chart Parts.

Your Step chart is prepared.

Step Chart

Previous Page Print Web page
Next Page
Share
Tweet
Email
Prev Article
Next Article

Related Articles

Roman Army camps
66 Roman Army camps in northern Spain make clear notorious …

1- Best Roman Army camps

Chemistry is the study of materials and energy and the …

What is Chemistry?

Short Hair

Recent Posts

  • Learn how to install multiple WhatsApp accounts on your phone
  • How to tell if I’ve been blocked on WhatsApp
  • How to lock WhatsApp ?!
  • 4 practical tricks for storing and securing PDF files
  • How to delete your WhatsApp account forever

Categories

  • Advertisement
  • Android
  • android games
  • antivirus
  • Arduino
  • audio video editor
  • backup
  • Bitcoin
  • Blockchain
  • Blog
  • Chinese medicine
  • Computer
  • Computer
  • computer games
  • Database
  • Database
  • Delphi
  • DISK AND PARTITION
  • download
  • Driver software
  • Drivers
  • electrical and electronics
  • Fashion and beauty
  • File Recovery
  • Forex Trading
  • format converter
  • General
  • general
  • graphics
  • Health and Fitness
  • Healthy Eating
  • internet
  • Management skills
  • Mikrotik
  • mobile
  • Monuments
  • Network
  • Network
  • News
  • Nutrition
  • Operating System
  • OPTIMIZER
  • passwords
  • phone apps
  • phone software
  • professional
  • Programing
  • programing tools
  • programming tools
  • ps4
  • Raspberry Pi
  • Robotics
  • Series and Movies
  • software
  • Sport
  • thems
  • Uncategorized
  • Unix Socket
  • utility
  • Videos
  • WhatsApp
  • YouTube watch

Tech Story

Copyright © 2021 Tech Story
Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh