excel表格制作横道图.docx
- 文档编号:23579074
- 上传时间:2023-05-18
- 格式:DOCX
- 页数:9
- 大小:258.87KB
excel表格制作横道图.docx
《excel表格制作横道图.docx》由会员分享,可在线阅读,更多相关《excel表格制作横道图.docx(9页珍藏版)》请在冰豆网上搜索。
excel表格制作横道图
excel表格制作横道图
轻轻松松用Excel表格制作横道图
首先键入内容,包括:
工序、开工时间、持续时间
选中,点击菜单栏的“插入”
开工日期
持续呵问
安平踣
2012-1-16
48
扌藥沥营磴跄面
2012-1T6
了
畴梯层
20124-18
y
■
挖繰土方
2012-1-20
1
2012-1-21
3
:
卜蠶?
2%水据稳症碎石
2012-1-24
3
2012-1-26
2
彳關壬汕潭贫腔萇屢
2012-1-28
5
4cm—
2012-2-3
¥
201Z^l-21
1
ionilAS%挪iP碎石〔人廿湛)
劝12T-26
点击“插入”,选中“图表”
弹出以下对话框,选择自定义类型
图表类型选择悬浮的条形图
團表白导-4参黍之1-亀爰类塾
标准羹型自^tgai[
區1表奘型©:
示侧:
注状诵帜團
»iMm>»a^a
23122112
选昌
自是义(I)
-內部鱼)
辟蜡爲碱严
吓一步題〕
芫成X)
specifiesamethodofscreeningmethodforthedeterminationoffinenessofstarchthisstandardappliestodriedintoapowderofrefinedstarch.1,definitionsandprinciplesoffinenessofstarch:
starchsamplessamplescreeningsamplesobtainedbydividingtheweightofthesieve.Tosamplebydividingtheweightofthesievethesampleweightexpressedasapercentageoftheoriginalweight.Principle:
thesampleswithasamplescreenscreening,getthesamplebydividingtheweightofthesieve.2,instrumentsandscales:
theprecisionof0.1g.Samplescreen:
screennumber100.Step3,analysissamplepreparation:
samplesshouldbefullymixed.Samplevolume:
mixweighingthesample50g,accurateto0.1g,evenlypourthesamplesieve.Screening:
shakethesamplesieveevenly,untilthescreendownsofar.Carefullypouroutthesamplesieveresidueonweighing,accurateto0.1g.
Determinationofthenumber:
measuredonthesamesampletwice.4,the
resultsofthecalculationmethodappliedtosamplebysamplesieveweightexpressedasapercentageoftheoriginalweightofthesample,asintheformula:
x--samplesize,%;MO--theoriginalweightofthesample,g;SifttheML--sampleweightofresidueonthesieve,g.Suchaspoormeetstherequirements,takethearithmeticmeanoftheseconddeterminationasaresult.Resultsonedecimal.6.2allowingdifferentialanalystsimultaneouslyorinquicksuccessionforthe
4—铁働
补^20cm®配冊石
安甲踣
seconddetermination,theabsolutevalue
完成后,得到下图
点击丫轴,弹出对话框
specifiesamethodofscreeningmethodforthedeterminationoffinenessofstarchthisstandardappliestodriedintoapowderofrefinedstarch.1,definitionsandprinciplesoffinenessofstarch:
starchsamplessamplescreeningsamplesobtainedbydividingtheweightofthesieve.Tosamplebydividingtheweightofthesievethesampleweightexpressedasapercentageoftheoriginalweight.Principle:
thesampleswithasamplescreenscreening,getthesamplebydividingtheweightofthesieve.2,instrumentsandscales:
theprecisionof0.1g.Samplescreen:
screennumber100.Step3,analysissamplepreparation:
samplesshouldbefullymixed.Samplevolume:
mixweighingthesample50g,accurateto0.1g,evenlypourthesamplesieve.Screening:
shakethesamplesieveevenly,untilthescreendownsofar.Carefullypouroutthesamplesieveresidueonweighing,accurateto0.1g.
Determinationofthenumber:
measuredonthesamesampletwice.4,theresultsofthecalculationmethodappliedtosamplebysamplesieveweightexpressedasapercentageoftheoriginalweightofthesample,asintheformula:
x--samplesize,%;MO--theoriginalweightofthesample,g;SifttheML--sampleweightofresidueonthesieve,g.Suchaspoormeetstherequirements,takethearithmeticmeanofthesecond
修改一下字体
坐标轴格式
Vial
片1AjidtS^wibclc
TjiAffGDT
TArihl
确定取消
回目动寵放㈡
逵屋TrueType字似同一棘字04笑屛認牝打E血上同吋便用.
〔确定1
取消
68
字号⑸;
MRtt叫上标②下标Q)
无
廨色©・背St色⑹
determinationasaresult.Resultsonedecimal.6.2allowingdifferentialanalystsimultaneouslyorinquicksuccessionfortheseconddetermination,theabsolutevalue
选中“分类次序反转”
—^厂「姿嘛]宇件〔ri李~~II对齐I
分类co轴刻度
分娄数◎类轴刻厦线标签之间)Qh1
分羌數卿度线N间)®:
1
specifiesamethodofscreeningmethodforthedeterminationoffinenessofstarchthisstandardappliestodriedintoapowderofrefinedstarch.1,definitionsandprinciplesoffinenessofstarch:
starchsamplessamplescreeningsamplesobtainedbydividingtheweightofthesieve.Tosamplebydividingtheweightofthesievethesampleweightexpressedasapercentageoftheoriginalweight.Principle:
thesampleswithasamplescreenscreening,getthesamplebydividingtheweightofthesieve.2,instrumentsandscales:
theprecisionof0.1g.Samplescreen:
screennumber100.Step3,analysissamplepreparation:
samplesshouldbefullymixed.Samplevolume:
mixweighingthesample50g,accurateto0.1g,evenlypourthesamplesieve.Screening:
shakethesamplesieveevenly,untilthescreendownsofar.Carefullypouroutthesamplesieveresidueonweighing,accurateto0.1g.
Determinationofthenumber:
measuredonthesamesampletwice.4,theresultsofthecalculationmethodappliedtosamplebysamplesieveweightexpressedasapercentageoftheoriginalweightofthesample,asintheformula:
x--samplesize,%;MO--theoriginalweightofthesample,g;SifttheML--sampleweightofresidueonthesieve,g.Suchaspoormeetstherequirements,takethearithmeticmeanoftheseconddeterminationasaresult.Resultsonedecimal.6.2allowingdifferentialanalystsimultaneouslyorinquicksuccessionfortheseconddetermination,theabsolutevalue
点击X轴,弹出对话框
12-232012-1*122012-2-120122212012-3-
0]自动酗Q)
Tft.閤将往屛鬲wrtp机上同时摆用.
修改字体大小
匚團室刻度\\宇甘j
数字
对齐
宇号①:
Arikl
[Buffi
j8___
n*4
窮规
J何A
TA*3BT
9
HjKrSa'v
如粗
x9v
自动设置
0昼小■值⑧;
叵是大值①:
0主要刻度单应⑹;
H汝要劃度単位辽):
H基底IM平面)
交又于©:
显示单位Qi>:
无
圉義上包含息示单位标签COJ
(C)”数值保持一致
图垂—I劃度I字性「数宇工
数值
(2)轴姿慷
Z橄刻度⑪
□数值次序良转披)
I基底魏平血交叉于最小值翅
specifiesamethodofscreeningmethodforthedeterminationoffinenessofstarchthisstandardappliestodriedintoapowderofrefinedstarch.1,definitionsandprinciplesoffinenessofstarch:
starchsamplessamplescreeningsamplesobtainedbydividingtheweightofthesieve.Tosamplebydividingtheweightofthesievethesampleweightexpressedasapercentageoftheoriginalweight.Principle:
thesampleswithasamplescreenscreening,getthesamplebydividingtheweightofthesieve.2,instrumentsandscales:
theprecisionof0.1g.Samplescreen:
screennumber100.Step3,analysissamplepreparation:
samplesshouldbefullymixed.Samplevolume:
mixweighingthesample50g,accurateto0.1g,evenlypourthesamplesieve.Screening:
shakethesamplesieveevenly,untilthescreendownsofar.Carefullypouroutthesamplesieveresidueonweighing,accurateto0.1g.
Determinationofthenumber:
measuredonthesamesampletwice.4,theresultsofthecalculationmethodappliedtosamplebysamplesieveweightexpressedasapercentageoftheoriginalweightofthesample,asintheformula:
x--samplesize,%;MO--theoriginalweightofthesample,g;SifttheML--sampleweightofresidueonthesieve,g.Suchaspoormeetstherequirements,takethearithmeticmeanoftheseconddeterminationasaresult.Resultsonedecimal.6.2allowingdifferentialanalystsimultaneouslyorinquicksuccessionfortheseconddetermination,theabsolutevalue
自动设置
□星小值辺):
0豪犬值CO:
1C980
0主要劇度单短他):
IV
0汝姜刻密車位⑴:
2
,□苞底Q平面)
变買于©:
4092^
蟲示单位|无
—回曲験上代含眾韵
确定后得到下图,调整一下大小,就0K啦
■
ET料I
显.•灼贰
也t生办
曙碍m月乩*認■養申科
4cm氏T■帕用
DffXPifiTbj-til人肝楚J
■
»U-MJ
齐11■垃U1lt-1
EM
用excel制作横道图就是这么简单,你也可以试试〜
specifiesamethodofscreeningmethodforthedeterminationoffinenessofstarchthisstandardappliestodriedintoapowderofrefinedstarch.1,definitionsandprinciplesoffinenessofstarch:
starchsamplessamplescreeningsamplesobtainedbydividingtheweightofthesieve.Tosamplebydividingtheweightofthesievethesampleweightexpressedasapercentageoftheoriginalweight.Principle:
thesampleswithasamplescreenscreening,getthesamplebydividingtheweightofthesieve.2,instrumentsandscales:
theprecisionof0.1g.Samplescreen:
screennumber100.Step3,analysissamplepreparation:
samplesshouldbefullymixed.Samplevolume:
mixweighingthesample50g,accurateto0.1g,evenlypourthesamplesieve.Screening:
shakethesamplesieveevenly,untilthescreendownsofar.Carefullypouroutthesamplesieveresidueonweighing,accurateto0.1g.
Determinationofthenumber:
measuredonthesamesampletwice.4,theresultsofthecalculationmethodappliedtosamplebysamplesieveweightexpressedasapercentageoftheoriginalweightofthesample,asintheformula:
x--samplesize,%;MO--theoriginalweightofthesample,g;SifttheML--sampleweightofresidueonthesieve,g.Suchaspoormeetstherequirements,takethearithmeticmeanoftheseconddeterminationasaresult.Resultsonedecimal.6.2allowingdifferentialanalystsimultaneouslyorinquicksuccessionfortheseconddetermination,theabsolutevalue
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- excel 表格 制作 横道图