您现在的位置是:首页 > 办公软件 > excleexcle
EXCEL 快速添加图表数据
爱读书aread.cc2022-10-02 22:28:00excle0人已围观
简介爱读书aread.cc翻译,转载请保留此信息 . If you have a chart with data for 1999 through 2001 and then enter a new column for 2002, you can drag and drop the new data on the chart.(下面的示例中是增加销售人
爱读书aread.cc翻译,转载请保留此信息 .
If you have a chart with data for 1999 through 2001 and then enter a new column for 2002, you can drag and drop the new data on the chart.(下面的示例中是增加销售人员)
Highlight the cells with the new data E1:E7. Using the mouse, click the black border around the range and begin dragging the range towards the chart. When the mouse pointer is over the chart, release the mouse button.
Result: the new data is added to the chart.(结果:新的数据被加入图表)
Highlight the cells with the new data E1:E7. Using the mouse, click the black border around the range and begin dragging the range towards the chart. When the mouse pointer is over the chart, release the mouse button.
Result: the new data is added to the chart.(结果:新的数据被加入图表)
Tags:
很赞哦! ()
上一篇:EXCEL 美化图表
相关文章
随机图文
-
EXCEL 打印时忽略图片、图表等对象的方法
爱读书aread.cc翻译,转载请保留此信息 . To prevent objects from being printed: Technique 1:方法一 1. From the File menu, select Page Setup. 2. Select the Sheet tab. 3. In Print, select the Draft quality -
excel页边距设置_excel打印预览
Excel-页面设置 为了使我们打印出来的文档简洁美观,我们要设置适当的纸张大小、左右边距 -
EXCEL 快速求和
爱读书aread.cc翻译,转载请保留此信息 . 1. Select the range of cells along with an empty cell in a vertical or horizontal direction. 2. Press "ALT+ ="OR Click the AutoSum icon(∑). The SUM formula is ad -
EXCEL 查找及替换的使用
.爱读书aread.cc翻译,转载请保留此信息. 1.编辑-查找;替换或按CTRL+F(查找);CTRL+H(替换) 2.查找范围可以是选定的单元格区域、工作表或工作簿 3.在输入查找内容时,可以使用问号(?)和星号(*)作为通配符,以方便查找操作。问号(?)代
留言与评论 (共有 条评论) |