Vertical Line Chart 1

The Horizontal Line Chart is pretty standard stuff! Why don’t we try making a Vertical Line Chart? Well there isn’t a standard vertical line chart in Excel so we’ll tweak some other type of chart to get this done!

Let’s get started..

 

Assume this Data

Vertical Line Chart 2

We have 7 periods and some values against them. Instead of a horizontal line chart we want a vertical line chart and to do that we would use a scatter chart with lines and markers

 

Use Scatter Chart with Lines and Markers

Vertical Line Chart 3

  1. In the Insert Menu select Scatter Chart
  2. Then pick up Scatter Chart with Line and Markers

Although this is a line chart but horizontal, let’s make some changes to our chart to make it vertical

 

Some Changes in our Chart

Vertical Line Chart 4

To convert the chart into a vertical line chart, let’s make the following changes

  1. Click on Select Data (appears in the right click menu)
  2. Edit the series
  3. Select the values (from sheet) for the X Axis Values
  4. Select the periods (from sheet) for the Y Axis Values
  5. The chart will start to appear as a vertical line chart. Squeeze it a bit

 

DOWNLOAD THE VERTICAL LINE CHART
 

With a bit more formatting you are good to go. If you need help regarding basics of charting please refer these 3 charting starters

  1. Charting Basics 1
  2. Charting Basics 2
  3. Charting Basics 3

 

More Interesting Charts

  1. Adding Direct Legends to your Chart
  2. World’s Largest Economies – A revised chart !
  3. Check button Chart

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI