Shulou(Shulou.com)11/24 Report--

Today ushered in the popular "extreme Challenge" column, also known as fan revision.

I have to say, I am a little scared when I receive contributions from my fans. Because every manuscript is hell! This time is no exception, let's directly invite the third guest of extreme Challenge!

Let's take a look at his needs:

I don't know how you feel after reading it, but I was stupid at that time! I read it several times, but I didn't quite understand it. So I carefully opened this file called "PPT full of data tables":

The moment the page pops up, directly a shit, this is the wrong manuscript, we do not accept the work of Excel here!

When I got over it, I realized that our column is "extreme Challenge"! This is very reasonable!

So I opened this copy and had the following unforgettable experience.

Of these three pages, I chose the one with moderate internal capacity:

It is both challenging and easy to explain, because the ideas of table design are similar.

Combined with the source files, sort out the design requirements:

This is a PPT for work report. Show the performance of different institutions in various dimensions, and judge the achievement of institutions, bad debts and so on according to the achievement rate.

Design goal: want to make the form easier to read.

If you faced this challenge, how would you design it?

Okay, time's up. I think you think of it this way: the style of this page is very monotonous, I want to add beautiful pictures, or switch to advanced design styles to make it more beautiful!

If you are the same, congratulations on finding the treasure! This article is not only about beautification, but also can help you solve practical problems.

01. Primary beautification below to share my design ideas.

The current table style is indeed monotonous, mainly due to the lack of hierarchical contrast, so you can fill the header with a color:

Color blocks can enrich the hierarchical sense of the page, no longer so thin, but also easy to distinguish between data and headers, more readable.

Then look at the data in each column and see if there is a problem: because the data vary in length and decimal point, it is difficult to see the relative size at a glance.

Share a tip here to align the data uniformly to the right:

The data has a unified location starting point, according to the length of the data, the size relationship can be clearly identified. (PS, remember to add units to the sales in the chart.)

When complicated data is intertwined with various border lines, it is slightly crowded. Remove the vertical split line to make the form more refreshing:

At this point, the primary beautification of the form is completed, and the next step is to think about how to solve practical problems.

02. Think deeply about the current problem is that tables are still a lot of data, they are just listed there, there is no focus, it is difficult to see at a glance whether the organization is good or bad, so it is necessary to classify the data.

This step is not complicated. Artificially set a uniform standard (for example, the achievement rate above 60% is qualified, below 60% is bad debt), and then draw a red line at the 60% position:

A simple step can solve the distinction between "good" and "bad". This is a useful design, and under normal circumstances, this step is sufficient.

However, if you look closely at the value of the achievement rate, you will find that even the institutions that meet the standards still have a large span. Some institutions even exceed 100%, while others are on the verge of 60%, which is very dangerous.

So I suggest a more detailed adjustment: reward those who have overfulfilled, and warn those who are close to 60. If so, how would you present it? It is recommended to think for a few seconds before looking down.

Here, I give my solution directly-- turn on the lights:

The achievement rate is divided into four grades.

Over fulfillment (> 100%)

Met the standard (70% 100%)

Risky (60% Murray 69%)

Not up to standard (

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.