Current location - Health Preservation Learning Network - Health preserving recipes - Excel makes histograms, and the data are very different. How to distinguish?
Excel makes histograms, and the data are very different. How to distinguish?
1. Right-click the completed chart and select Set Object Format → Font → Delete √ before automatic scaling → OK.

2. Copy the completed chart;

3. Set the scale of the ordinate axis of the chart: the first chart is set to the maximum value of 2, and the second chart is set to the minimum value of 5.

4. Set the pattern of the horizontal axis of the second chart: axis: None, major tick mark type: None, minor tick mark type: None, tick mark label: None,

5. Set the chart area format of the second chart: Area Fill: None.

6. Adjust the height and relative position of the two charts.