1. Plot a grouped mean bar chart with source data 2. Select Menu: Statistics: Descriptive Statistics on Column to calculate the mean value for every group
3. Go to worksheet “DescStatsQuantities1”, right-click on column A and select Insert to add a new column at the left of column A 4. Fill the new column with row number, and right click to set as X 5. Select menu: Worksheet: Sort Worksheet: Custom 6. Select Animal in the left panel, click Ascending; then select Week in the left panel, click Ascending 7. Select row 4 and insert a blank row 8. Select column(Mean) to plot a line+symbol plot 9. Select Menu: Graph: Merge Graph Window to merge grouped bar chart and scatter plot 10. Right-click layer icon to select Layer Management and link these layers
不好意思啊，还是上面这张图。后来发现有个小问题没有解决。版主介绍的步骤8.Select column(Mean) to plot a line+symbol plot.我做出来的图两根线是同样颜色，无法分别改变颜色。按照一般理解，应该是进行了分组才能进行分别设定颜色。但是直接做line+symbol plot并不能实现此功能。 还望版主不吝赐教！
画好 Line + Symbol 的双击图形打开 Plot Details dialog: 1. Select line + symbol plot in the left panel 2. Go to Line tab 3. Click Color drop-down list and select By Point 4. Select Indexing and then select Column(C): Animal from the list 5. Go to Symbol tab 6. Select Auto for Symbol Color or repeat the step 3 and step 4 7 Click OK button
grouped box chart连接线的绘制
Posted - 07/26/2019 : 7:08:10 PM
