codecamp

EXCEL 快速添加图表数据

中国教程网zhangditony翻译，转载请保留此信息 .
 

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.（结果：新的数据被加入图表）

20070720_d951b0d0c2a6a6e0aec8jr2glh57zxvs[1].gif

EXCEL 美化图表
EXCEL 打印时忽略图片、图表等对象的方法
温馨提示
下载编程狮App，免费阅读超1000+编程语言教程
取消
确定
目录

EXCEL 基础应用

EXCEL 函数应用

关闭

 MIP.setData({ 'pageTheme' : getCookie('pageTheme') || {'day':true, 'night':false}, 'pageFontSize' : getCookie('pageFontSize') || 20 }); MIP.watch('pageTheme', function(newValue){ setCookie('pageTheme', JSON.stringify(newValue)) }); MIP.watch('pageFontSize', function(newValue){ setCookie('pageFontSize', newValue) }); function setCookie(name, value){ var days = 1; var exp = new Date(); exp.setTime(exp.getTime() + days*24*60*60*1000); document.cookie = name + '=' + value + ';expires=' + exp.toUTCString(); } function getCookie(name){ var reg = new RegExp('(^| )' + name + '=([^;]*)(;|$)'); return document.cookie.match(reg) ? JSON.parse(document.cookie.match(reg)[2]) : null; }