Create Dynamic chart in Excel 2007
*Collection*
1. Create an excel defined tableSelect A1:E5
Click "Insert" tab
Click "Table" button
Click OK!
2. Create a chart
Select table
Click "Insert" tab
Click "Column chart" button (Refer P2)
It is now possible to add more rows and columns to the table? The chart is instantly updated! (Refer P1)
How to remove rows / columns
Right click on a cell
Click "Delete"
Click "Table Rows" or "Table Columns"
Note: Go to cell A1 and filter with specific mobile product and see the impact on Chart
BLUESOFTS - Add-in A-Tools |
0 nhận xét:
Đăng nhận xét