When drawing charts, in addition to commonly used Excel, Think cell plugin is also a good choice. It provides powerful chart drawing functions, and as long as data is input, charts can be automatically generated, greatly improving work efficiency.
How can Think cell add significance to a bar chart?
Bar chart is a commonly used chart type in data display, which can be used to reflect the quantity or comparison between different categories. Adding significance labels to bar charts can make the differences between data clear at a glance. Today, we will learn how to use Think cell to add significance to bar charts.
Figure 1: Example data
1. Firstly, use SPSS statistical analysis software to perform one-way ANOVA on the data, and then view the results in multiple comparisons. If the P value is less than 0.05, use an asterisk (*), and if the P value is less than 0.01, use a double asterisk (* *); If the P-value is less than 0.001, it is represented by a Samsung number (* * *).
Figure 2: Inspection results
2. Find the 'Insert' tab above the PPT interface, click on 'Elements' in the think cell group, expand the drop-down list, and select' Cluster Column Chart '. An orange box will appear in the PPT slide interface. Drag the mouse to adjust the size and position of the box and determine the drawing range of the column chart.
Figure 3: Elements
3. After completing the drawing, click the 'Open Data Table' button in the bottom right corner to automatically pop up the Excel data table associated with the chart. Adjust the data source in the table to calculate the average value of each lighting time group. The X axis of the column chart shown in the [Lighting Time] list shows the category of each column chart; And 'Plant Growth Height' represents the Y-axis of the bar chart, representing different data series. After adjusting the data, click the 'Close' button in the upper right corner.
Figure 4: Column chart
4. Select the three comparison combinations of 4h and 6h, 4h and 8h, and 6h and 8h in the bar chart, add difference arrows, and mark them with corresponding asterisks at the corresponding positions based on the significance values shown in Figure 2. You can also adjust the style of the bar chart according to your own needs.
Figure 5: Adding Significant Signs
How to add a horizontal line in a line chart for Think cell?
When conducting data analysis, in order to reflect the target task value, it is usually necessary to add a horizontal line that runs through the line graph. If it exceeds the horizontal line, it indicates that the task has been exceeded, and if it does not exceed the horizontal line, it indicates that the task has not been achieved. Taking the data in the figure as an example, we will introduce the method of adding a horizontal line in the think cell line graph for everyone's reference.
Figure 6: Example of Sales Data
1. Create a line chart using Think cell and enter relevant data content in the associated data table. The data in the line chart will be updated in real-time based on the data in the table, as shown in the following figure. In this line chart, taking sales of 40W as an example, add a horizontal reference line as the target baseline.
Figure 7: Column chart
2. Right click on the line chart and select 'Add Value Line' from the pop-up menu. Think cell will automatically add a value line to the chart (calculated based on the average of all data points in the current chart). If you want to modify the target value, you can simply click on the value and drag it up or down.
Figure 8: Adding Value Lines
3. Click on the drawn horizontal line, and in the pop-up settings window, you can adjust the color, thickness, line type, etc. of the horizontal line. To make the horizontal line more prominent, the color can be set to a color that is clearly distinguishable from the line chart color, and the thickness of the horizontal line can be appropriately increased.
Figure 9: Line Style
4. To highlight key data points more clearly, you can use Think cell's chart tool to set them up. Right click on the line chart, select 'Add Point Labels', and set up marker points to display specific values. At the same time, you can also set the polyline as a smooth line, adjust the curve curvature, and make the chart more beautiful.
Figure 10: Beautify the Chart
