How to Create a Beautiful and Modern Column Chart in Excel | Bar Chart for Presentations
🟢 LEARN EXCEL WITH ME AND BECOME A REFERENCE IN THE JOB MARKET: http://excelentejoao.com.br/sejaexcel...
#Excelentejoao #Excel #Dashboard
In this Excel video lesson, I'll show you how to create a beautiful and modern column chart in Excel step by step.
With this free Excel tutorial, you will learn how to build a bar chart in Excel to use in presentations, dashboards, reports, spreadsheets, etc. In other words, it's a chart with a personalized and customized design and layout that can help make your presentations more interesting.
The first step is to have a database. From the information in our table, we can create the chart in the Excel spreadsheet.
To create this chart in Excel, we will need to learn how to use shapes and forms in Excel. Because conventional bar and column charts always come with rectangles in their composition, we cannot choose other shapes.
So, after creating the new shapes that will make up the bars of our chart, we'll select the shape and click copy, then select the chart column and click paste. This way, the shape we created earlier is now part of the chart and will be the column.
The next step is to add another layout effect that will make our spreadsheet modern and beautiful: the special shadow effect. I'll use the shadow both on the chart background and on the blue background that will be behind the chart.
To create the blue background behind the chart in Excel, we'll again use shapes and forms, but this time it's much simpler. We'll use a rectangle shape. After choosing the location and dimensions for the shape, we'll right-click on the shape and click "send to back".
Remember, for the blue background I used a gradient effect, that is, several shades of color in the same image. I did this to give it a more modern effect and to use something different from the solid blue color.
After all these steps, it's a good idea to add a border to the chart and the background. Finally, select the chart along with the blue background and group the objects. To do this, simply select the chart, then press and hold the Ctrl key on your keyboard, select the blue background, and click on "group objects." This way, whenever you select the blue background or the chart, both will move together.