In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Internet Technology >
Share
Shulou(Shulou.com)06/01 Report--
This article introduces the relevant knowledge of "what is the method of making mini pictures in EXCEL data analysis". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!
1. REPT function method
First of all, we use the function method to draw, and the function used here is the REPT parameter.
The meaning of the parameter REPT (text,number_times): text is the text to be repeated, and number is the number of times to repeat. 1. Mini bar chart when drawing a mini bar chart, select "|" to repeat. When it is dense enough, multiple "|" will merge into a whole block and look like a bar chart. At the same time, the font uses an 8-point playbill font and sets different colors to increase visual perception. Among the parameters, E4/MAX ($E$4:$E$8) * 50 indicates that the value in the cell accounts for the percentage of the maximum value in the data range and increases by 50 times in the same proportion.
The mini bar chart is drawn as follows:
2. Bilateral mini bar chart
Similarly, you can draw a two-sided bar chart, and the parameter TEXT (I4P0) is used to display the data as text and concatenate it to the left with the'& 'symbol.
The drawn bilateral mini bar chart is as follows: 3. Mini funnel chart
The funnel chart is drawn in the same way as a bar chart, where the parameter O4/MAX ($O$4:$O$9) * 100 represents the number of processes as a percentage of activation and is scaled up by a factor of 100. The mini funnel chart is as follows: 4. Mini Gantt REPT ("", (T4-MIN ($T$4:$T$11)) * 1) & REPT ("|", (U4-T4+1) * 1) where the formula is divided into two parts, the first part is blank, subtract the start time of task 1 from the start time of the current task, and double the size. The latter part indicates the number of days that the current task needs to last, using the end time minus the start time, (the reason for adding 1 is that if it only takes 1 day to complete, the minus two equals 0, so adding 1 is the real number of days) and double the number of days. The mini-Gantt chart is drawn as follows: 5. The mini-waterfall chart establishes the auxiliary column, and the parameter $Z$4-SUM ($Z$5:Z6) is used as the starting point of the waterfall chart. REPT ("", AA4/$Z$4*55) & REPT ("|", Z4/$Z$4*55) the formula here is divided into two parts, the first part is blank, divide the value of the secondary column by the amount value of the current category and expand by 55 times, and the latter part divides the amount value of the current category by the amount and expands 55 times. The drawing of the mini waterfall is as follows:
6. Mini folding bar chart
The bar chart is simulated by the REPT function, and the line spacing is set to 1.5. the gridlines can be removed. The parameter D4/MAX ($D$4:$D$33) * 100 indicates that the current value is divided by the maximum value in the data area, and then it is enlarged by 100 times.
The drawn mini fold bar chart is as follows:
Second, PivotTable
How to insert a mini image into a PivotTable report?
The first step is to select the data area and insert the PivotTable report. The second step is to drag the month into the column, the channel into the row, and the sales volume as the sum item. The third step is to click on any area of the PivotTable and select the calculated item in the fields, items, and sets. The fourth step, enter the sales trend chart in the name, delete the formula, click OK, and you can insert a sales trend field into the PivotTable report. Step 5, see here that the sales trend chart is placed at the end of the PivotTable by default, and right-click the cell to move it to the beginning.
Step 6, select the sales trend area, insert the mini chart, select the line chart in the mini chart, select the desired data range when creating the mini chart, and select the location to place the mini chart, and click OK. Step 7, make some type and style changes to the mini image to display the mark. The eighth step is to select the PivotTable and set the layout of the PivotTable in the design. Similarly, we can select a column chart in the mini chart, and the final mini chart made in the PivotTable report is shown below.
III. Supplement to the chart
1. Area map
Here is a supplement to an area map practice that is widely used in data analysis, which is used to emphasize the extent to which the quantity changes over time. The first step is to select the data to establish a stacked area map, and then copy the data from the quantity field and paste it into the chart.
The second step is to change the chart type to a line chart with data markers.
The third step, draw a circle, fill it with white, copy and paste to the vertex.
The fourth step is to add data labels and fill the graphics with colors, and the results are as follows.
This is the end of the content of "what is the method of making mini-graphs in EXCEL data analysis". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!
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.
Views: 223
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.