Yesterday Vs Today Sales Chart
Charts and Visualization

Yesterday Vs Today Sales Chart

In this article you will learn how to compare the sales of different products For yesterday vs today. In this chart we are displaying the green and red arrows. If Today’s sale is higher than the yesterday sales then there will be a Green arrow.If Today’s sale is lower than the yesterday sales then there will be a Red arrow

Gap between yesterday’s sales and today’s sales is displayed with size of arrows. If gap is bigger then the size of arrow will be bigger.

Yesterday Vs Today Sales Chart
Yesterday Vs Today Sales Chart

Steps have been given below to create this chart in MS Excel:

Below is the Product wise sales for yesterday and today for which we will create the chart.

Product wise Sales Table
Product wise Sales Table
  • Select the range (“B2:D8”)
  • Go to Insert tab>>Charts>>Insert 2D Line Chart
Insert Line without Markers
Insert Line without Markers
  • After inserting the line chart we will format the lines.
  • Right click on first line and click on Format Data Series.
Format Data Series Option
Format Data Series Option
  • In Format Data Series window select the Solid line under Line option
  • Give the Orange color.
  • Take Width as 1.5pt.
  • Take Dash Type as Round Dot (second one)
Format Data Series Window
Format Data Series Window
  • After doing the above setting our chart will look like below given image.
Chart after formatting first line
Chart after formatting first line
  • Now select the second line and repeat the same activity.
  • Take the blue color in place of orange.
Format Data Series Window
Format Data Series Window
  • After formatting both lines, chart will look like below given image.
Chart after formatting both lines
Chart after formatting both lines
  • Click on Chart Elements button(plus button of chart)
  • Tick the Up/Down Bars check box.
Add Up/Down Bars
Add Up/Down Bars
  • Now we will put arrow in the the up/down bar.
  • Go to Insert >>Shapes>>Insert down arrow shape available under Block Arrows.

 

  • Drag the arrow on the worksheet.
  • Right click on the arrow shape and click on Format Shape.
  • In Format Shape window, select Gradient Fill  available under fill option.
  • Take the 2 stops in gradient fill.
  • Take Red color for first stop with 60% Transparency.
  • Take Red color for second stop with 0% Transparency.
  • Take shape border as No line.
Format Shape window
Format Shape window
  • Our arrow shape will look line below given image after doing the above settings.
Down Arrow Shape
Down Arrow Shape
  • Select this arrow shape and copy it (Press Ctrl+C)
  • Now right click on the down bar in the chart and click on Format Down Bars.
Format Down Bars option
Format Down Bars option
  • In the Format Down Bars window select the Picture or texture fill option available under fill.
  • Click on Clipboard available under Insert picture from.
Format Down Bars window
Format Down Bars window
  • Now select the No line under Border
Shape Border Option.
Border Option.

Our chart will look like below given image.

After after adding the down arrow
After after adding the down arrow
  • Now insert a up arrow shape from the Insert >> Shapes>>Up Arrow.
Up arrow shape
Up arrow shape
  • Drag the arrow on the worksheet.
  • Right click on the arrow shape and click on Format Shape.
  • In Format Shape window, select Gradient Fill  available under fill option.
  • Take the 2 stops in gradient fill.
  • Take Green color for first stop with 0% Transparency.
  • Take Green color for second stop with 60% Transparency.
  • Take shape border as No line.
Format Shape window
Format Shape window
  • Our arrow shape will look line below given image after doing the above settings.
Up arrow shape
Up arrow shape
  • Select this arrow shape and copy it (Press Ctrl+C)
  • Now right click on the up bar in the chart and click on Format Up Bars.
Format Up Bars option
Format Up Bars option
  • In the Format Up Bars window select the Picture or texture fill option available under fill.
  • Click on Clipboard available under Insert picture from.
Format UP Bars window
Format UP Bars window
  • Now select the No line under Border
Border Option
Border Option

Our chart is ready now. We will give some chart title. It will look like below given image.

Yesterday Vs Today Sales Chart
Yesterday Vs Today Sales Chart

Click here to download Excel file of this Chart

Video Tutorial for Yesterday Vs Today Sales Chart.

 

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com

Leave a Reply