I haven't written a chart in a long time, and today I'm going to teach you a chart-related skill. The knowledge point is absolutely just needed, and the solution is also very simple, why has it been troubled for so long before? The so-called meeting is not difficult, and the difficult will not be.
Case:
The chart in Figure 1 below is made from the data table in the figure, please set the full chart to be displayed when hiding any area of the data table, the data reference of the chart is not affected.
The effect is shown in Figure 2 below.
solution:
The charts we usually make are linked to the visible area of the cell by default.
If part of the area of the original data table is hidden, the corresponding area on the chart is also hidden, just like the following image.
If you do not want the chart to be affected by the hiding of the original data table, you can do so.
1. Select the chart area --> Right-click --> Select Data in the pop-up menu
2. Click the "Hidden Cells and Empty Cells" button in the popping dialog box
3. At this point, the following dialog box will pop up, check "Show data in hidden rows and columns" -- > Click "OK"
4. Click "OK"
Now no matter how much you hide the original data, the chart stands still.
Many students will find excel's individual case explanations somewhat fragmented, and beginners may not be able to fully understand and master them. Many students hope to have a complete set of graphic teaching, starting from the most basic concepts, step by step from simple to complex, from beginner to proficient, systematically explain the various knowledge points of Excel.
Now finally, the following column, starting from the most basic operations and concepts, with vivid and interesting cases to take everyone to master the operation skills of Excel, shortcut keys, function formulas, pivot tables, charts, printing skills, etc. Learn the whole book, and you can become an Excel master.