Archive | September 2023

Infographics using Male Female Icons

Infographics is the use of  images/icons to represent your data. They help to capture the users attention and also give a creative feel to your data.Infographics in Excel Charts make it visually appealing .

For e.g : We have a data based on an employee engagement survey.

The employee engagement % values for men and women are shown.

The chart is good. It gives you the required information. But imagine a dashboard wherein you have multiple column charts and bar charts. This chart would be just another chart to the mix.

So to enhance your data representation you need to apply infographics.

Now what is infographics. It is showing of information via images.

So the same chart above using infographics is shown below.

The image fill amount is determined by the respective % values.

As the percent changes the image fill for the respective image as changes. See below

Download Template _Infographics_Employee Engagement

Sales Data – From a particular month to a particular month.

In this example we have the monthly sales data.We have two combo box denting the from date and to date.

The resultant chart represents sales data for the selected period.

If the user selects a From Month which is after the To Month.

In this scenario, the resultant chart will show sales for the entire year( January to December).

Download Chart From Date -To Date