WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Step Chart in Excel

Step Chart in Excel

How to Create Step Chart in Excel? (Step By Step)

Now we will follow the below steps to create a step chart in excel.

  • Step 1: Insert two new columns with the same headers.

Step Chart in Excel Example 1.2

  • Step 2: Now copy the date values from A3 to A9 and paste in the new column D2. Here you need to ignore the first date value.

 Example 1.3.0

  • Step 3: Now copy the Stock Price from B2 to B8 and paste in E2. Here you need to ignore the last value.

Step Chart in Excel Example 1.4

  • Step 4: Now copy actual data from A2 to B9 paste in D9 cell.

 Example 1.5

  • Step 5: Now, select the data and insert Line Chart.

Step Chart in Excel Example 1.6

Now we have our Chart.

Example 1.7.0

  • Step 6: Select the vertical left axis and press Ctrl + 1 to open up the format data series option.

 

Step Chart in Excel Example 1.8

  • Step 7: Now click on “Axis Option” >>> set the minimum value to 100, maximum to 135, and major value to 5.

 Example 1.9

  • Step 8: Now click on the horizontal axis and click on “Number” formatting and change the date format to “MMM-YYYY.”

Step Chart in Excel Example 1.10

  • Step 9: Change the “Line” color to green. Now we have our chart ready.

 Example 1.11

Difference Between Line Chart and Excel Step Chart

Below are some of the general differences.

Difference #1

A-Line Chart shows the trend of data points, and it will not focus on the exact time of change or fluctuation of data points from one period to another.

On the other hand, “A Step Chart” shows the trend shows the exact time of change along with the trend of the data points as well.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Step Chart in Excel Example 1.16

As you can (red marked area), the line chart shows that after the first month, it shows a consistent decline in stock price, but the step chart shows that the price actually declined only in February month.

Difference #2

Finding the actual trend could be tricky with a line chart because it doesn’t show the exact trend of change and how much. But a step graph due to its horizontal line can show the actual trend with clear visibility.

 Example 1.17

As you can see above, the line chart shows that the decline started from Mar to June, but the Step chart also shows a decline but not with consistent decline throughout the months.

Things to Remember

  • Showing differences from one period to another is the main advantage of this chart.
  • It can tell the story better than the Line Chart.
  • If you don’t want to show the full date in the horizontal axis of the chart, then you can change the date format under the chart formatting section.
  • You need to adjust the minimum value, maximum value, and manor interval point to fit in your chart to look better.

Recommended Articles

This has been a guide to the step chart in excel. Here we discuss how to create a step chart along with examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Bullet Chart in Excel
  • Combo Chart in Excel
  • Create Contour Plots in Excel
  • Sparklines in Excel
  • Marksheet in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Step Chart Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More