회원가입 공지사항
로그인
비밀번호
엑셀 자동화 서식
엑셀 자동화 기술 방법
엑셀 실무활용 팁
맞춤서식 제작
 회원 방문 수    801,780 명  
 접속 인원 수    2,280 명  
  홈 > 엑셀자동화기술 > 엑셀자동화 기술방법    

콘텐츠제목
사원실적 차트(보고서) 만들기 (Hit: 8,616) 확대축소   인쇄  
다운로드
 영업사원실적차트(연습용).xls
 영업사원실적차트(완성).xls
몇 년간의 실적현황 데이터를 이용하여 사용자가 지정한 연도와 사원에 해당되는 실적을 월별로 산출하고 전체 실적에서 개인이 차지하는 실적 점유율을 차트로 표현하도록 만들 것입니다. 데이터를 차트로 표현하면 데이터의 흐름과 경향, 크기 등을 숫자로 표시했을 때보다 더 빠르게 파악할 수 있는 장점이 있습니다. 업무에 바로 사용할 수 있는 완성 파일과 연습해 볼 수 있는 연습용 파일을 제공합니다.

연습용 파일과 완성 파일, 모든 내용은 [유료회원]에게 제공됩니다.

tyle0 style="MARGIN-LEFT: 15pt; TEXT-INDENT: -15pt">⑱ [M3]셀에 =".."&L3&" 사원의 "&K3&"년도 실적차트.."를 입력해서 차트 제목으로 사용할 텍스트를 만든다.

   

   차트 제목에 표시할 수식을 입력한다.
 

⑲ 차트 제목을 선택하고 수식 입력줄에서 =M3을 입력한 후 [Enter]를 누른다. 이 수식은 선택한 연도와 영업사원을 차트 제목에 표시한다. 차트 제목을 드래그하여 오른쪽으로 이동한다.

   

   차트 제목을 워크시트를 참조하도록 수식을 입력한다.
 

⑳ K열부터 N열까지를 블록으로 지정하고, 마우스 오른쪽 단추를 클릭한 후 [숨기기] 메뉴를 선택한다. 차트의 원본 데이터를 화면에서 숨기면 차트에 아무 것도 표시되지 않는다. 차트를 선택하고, [도구]→[옵션] 메뉴를 선택한다. [옵션] 대화상자의 [차트] 탭에서 [화면에 표시된 셀만 그림]을 클릭하여 선택을 해제하고 [확인]을 클릭한다. 그러면 원본 데이터가 화면에서 숨겨져 있어도 차트에 데이터가 표시된다.


리스트


d chanyuan

cheap oakley sunglasses


harden vol 1


bvlgari rings


jordan 3


givenchy handbags


mizuno running shoes


air max


louboutin


nike revolution


michael kors handbags


tory burch bags


coach


flops


tory burch outlet


air max 270


balance shoes


coach outlet online


kate spade


true religion jeans


adidas slides


louis vuitton outlet


longchamp handbags


nike shoes


coach outlet online


malone souliers shoes


tag heuer watches


polo ralph lauren


bottega veneta


nike epic react flyknit


birkenstock outlet online


longchamp outlet


air max 2018


cheap nfl jerseys


louis vuitton outlet


coach outlet


timberland outlet


ray ban


jordan shoes


beats by dre headphones


oakley sunglasses


michael kors outlet


tory burch


jordan 4


adidas outlet


cheap nba jerseys


manchester united jersey


louboutin


adidas nmd


cheap replica watches


louis vuitton


chenlina20180521
2018-05-21 오후 12:19:04
d chanyuan
20180810 junda

stephen curry shoes


kate spade outlet


jack wolfskin


jeep shoes


air max 97


true religion outlet


dsquared2 jeans


canada goose jackets


tory burch outlet


lacoste polo shirts


longchamp pliage


yeezy boost


bcbg dresses


true religion outlet


mulberry handbags


polo ralph lauren


air huarache


air jordan 3


celine outlet


pandora jewelry


air force 1


canada goose outlet


canada goose jackets


ugg outlet


oakley sunglasses


bulgari jewelry


pelicans jerseys


coach factory outlet


celtics jerseys


fingerlings monkey


pandora charms


gucci outlet


canada goose outlet


christian louboutin outlet


oakley sunglasses


bally shoes


polo ralph lauren


tory burch outlet


nhl jerseys


prada shoes



2018-08-10 오전 11:07:58
d xiaojun

ralph lauren polo


michael kors outlet clearance


burberry canada


supreme clothing


pandora jewelry


christian louboutin shoes


nfl jersey


snapback hats


burberry sale


oakley sunglasses


miu miu shoes


ray ban


mizuno running shoes


flipflops


balenciaga shoes


mcm handbags


nike running shoes


omega watches


russell westbrook shoes


north face jackets


bvlgari jewelry


versace sunglasses


suicoke sandals


police sunglasses


coach outlet sale


nike sb


north face jackets


air max 97


oakley sunglasses


pelikan pens


nike air max 2018


new balance shoes


jordan


ray bans


kobe shoes


mbt shoes


coach handbags


tom ford sunglasses


nike outlet store

cheap mlb jerseys


nike air max


nike roshe


nike air max 2017


balenciaga shoes


ugg boots


soccer jersey


lebron 14


timberland boots


jordan shoes


supreme clothing


chenlina20180905
2018-09-05 오후 4:24:52
d chanyuan
20180906xiaoke

moncler jackets


polo ralph lauren outlet online


guess factory


ugg outlet online


gentle monster sunglasses


jordan shoes


ugg outlet,ugg outlet stores


polo ralph lauren outlet


nhl jerseys for sale


supreme uk


pandora outlet


louboutin shoes


tory burch outlet store


canada goose outlet online


ray ban sunglasses sale


houston texans jersey


pandora jewelry


mbt outlet


cheap jordans


ugg boots clearance


uggs outlet


michael kors outlet


pandora outlet


coach factory outlet online


coach outlet online


coach outlet store online


kate spade handbags


red bottoms


coach outlet online


cheap ray ban sunglasses


christian louboutin sale


coach outlet online


ugg boots clearance


diesel jeans


north face


true religion jeans


canada goose jackets


oakley sunglasses wholesale


swarovski jewellery


canada goose


miu miu outlet


canada goose outlet


canada goose uk


ralph lauren outlet


nba jerseys wholesale


brequet wathes


michael kors uk


ralph lauren polo outlet


canada goose jackets


christian louboutin



2018-09-06 오후 2:46:48
d zzyytt

golden goose


jordans


balenciaga


adidas shoes


nike jordans


nike air huarache


off white shoes


michael kors handbags outlet


yeezy boost 350 v2


curry 4


nike air max


basketball shoes


lebron james shoes


hermes belt


adidas outlet


nike free


pandora charms


kate spade handbags


jordan 11 retro


air force 1


zzyytt
2018-09-25 오전 11:07:10
d chanyuan
2018927 leilei3915

christian louboutin sale


polo ralph lauren outlet


nike trainers


prada outlet


cheap mlb jerseys


christian louboutin outlet


polo outlet


prada outlet


true religion jeans


pandora outlet


nike air jordan 4


christian louboutin shoes


ugg outlet online


pandora charms outlet


true religion


christian louboutin outlet


nfl jerseys


kate spade bags


nike outlet store


michael kors


ugg outlet


coach outlet


coach outlet


christian louboutin


coach outlet


cheap ugg boots


ray ban sunglasse


true religion jeans


michael kors outlet


canada goose jackets


coach outlet online


michael kors outlet online


polo ralph lauren outlet


cheap oakley sunglasses


fred perry polo


ralph lauren


michael kors handbags sale


adidas outlet online


kate spade handbags


coach outlet online


uggs outlet


cheap ugg boots


coach outlet


coach outlet


christian louboutin shoes


pandora outlet


pandora charms


michael kors uk


oakley sunglasses wholesale


ralph lauren outlet




2018-09-27 오후 7:08:22
d chanyuan
20181004 xiaoou

chrome hearts outlet store


cheap oakley sunglasses


moncler outlet online


fitflops sale clearance


cheap basketball shoes


snapbacks wholesale


canada goose outlet store


canada goose jackets


mulberry handbags sale


canada goose jackets sale


chrome hearts online store


canada goose jackets


lebron shoes


coach outlet online


canada goose outlet store


adidas yeezy boost


canada goose outlet


kobe bryants shoes


canada goose outlet store


swarovski jewellery


coach outlet online


nike uk store


ecco outlet


christian louboutin shoes


michael kors outlet clearance


ugg boots


ralph lauren polo


cleveland cavaliers jerseys


lacoste shirts


supra shoes sale


ugg outlet


mulberry bags


louboutin shoes


kate spade handbags


canada goose jackets


broncos jerseys


canada goose jackets


adidas outlet online


49ers jersey


michael kors outlet online


pandora charms


bvlgari outlet


kd shoes


ralph lauren polo


nobis jackets


fred perry polo


moncler coats


mcm backpacks


tory burch outlet stores


michael kors outlet clearance


nike roshe run


ralph lauren uk


air jordan shoes


air jordan shoes


polo outlet factory store


louboutin shoes


air jordan shoes


jordan shoes


canada goose outlet store


canada goose outlet store



2018-10-04 오후 5:51:33
d chanyuan
2018.10.10chenlixiang

adidas


adidas outlet


moncler jackets


curry 4


nike air max


adidas superstar


kevin durant shoes


rolex watches


curry 2


adidas flip-flops


chrome hearts jewelry


air max


roshe run


yeezy shoes


arcteryx jackets


jordan retro


new balance


pandora jewelry


nike air max


air max 95


kate spade outlet


louboutin


carson wentz jersey


ray ban sunglasses


hollister outlet


pandora


adidas outlet store


instyler ionic styler


rolex


ralph lauren


wedding dresses


jordan 8


nike air max


designer sunglasses


cheap nfl jerseys


jordan 9


kenzo clothing


bose headphones


lululemon outlet


moncler outlet


kobe 9


ugg boots


new balance


nike factory


oakley


michael kors outlet


kids jordans


converse shoes


michael kors


oakley sunglasses


2018.10.10chenlixiang
2018-10-10 오후 2:42:41
d xiao
2018-10-16 xiaozhengzheng

pandora jewelry outlet


michael kors outlet online


ugg outlet


coach outlet store online


kate spade bags


coach outlet


nike sneakers


christian louboutin


coach outlet online


cheap ugg boots


prada outlet online


polo outlet


michael kors outlet online


north face


uggs outlet


air jordan 4 retro


coach outlet


pandora jewelry


cheap jordans


canada goose outlet


moncler outlet online


mbt shoes


canada goose


tory burch outlet


mbt


north face outlet


coach outlet


polo ralph lauren outlet


true religion outlet


pandora charms sale clearance




2018-10-16 오후 3:17:08
d chanyuan

moncler jackets


uggs outlet


stussy


michael kors outlet clearance


uggs outlet


nicholas kirkwood


nike lunarglide


visconti pens


longchamp handbags


uggs outlet


jordan xx9


prada handbags


christian louboutin shoes


manolo blahnik


nike tn


ferragamo


oakley sunglasses


ugg boots for men


nike factory store


jordan pas cher


longchamp handbags


cheap nfl jerseys


ralph lauren outlet


coach outlet online


christian louboutin shoes


polo outlet


air max 95


ralph lauren polo


coach outlet


jordan 14


tods shoes


north face outlet


designer belts


barcelona jersey


mbt shoes


y-3 shoes


victoria's secret outlet


sac longchamp


tory burch shoes


coach outlet


red bottom shoes


nike running shoes


linda farrow sunglasses


nine west shoes


coach outlet


lululemon


nike air force 1


coach handbags


moncler jackets


nike shoes


chenlina20181106
2018-11-06 오전 11:52:39
d chanyuan
2018-11-19 xiaozhengzheng

coach outlet


red bottom shoes


cheap jordan shoes


michael kors outlet clearance


michael kors outlet


adidas yeezy shoes


pandora outlet


ray ban outlet


adidas outlet online


adidas yeezy


coach outlet


ugg outlet


coach factory outlet


christian louboutin


ugg outlet online


coach factory outlet


off-white clothing


pandora outlet


michael kors outlet online


fitflops sale


michael kors outlet store


canada goose uk


cheap mlb jerseys


ugg canada


michael kors outlet


cheap oakley sunglasses


ugg outlet


prada handbags


polo ralph lauren


true religion jeans


polo ralph lauren outlet


michael kors outlet


coach outlet


nike outlet


oakley sunglasses wholesale


coach factory outlet online


adidas yeezy shoes


coach factory outlet


oakley sunglasses wholesale


moncler outlet online


uggs outlet


moncler jackets


canada goose jackets


nike outlet online


christian louboutin shoes



2018-11-19 오후 6:12:13
d qzyfffff

kobe 9


reebok outlet


adidas outlet online


red bottom heels


golden goose


golden goose sneakers


nike air max 270


pandora bracelet


links of london outlet store


yeezy boost 350


jordan 6


ferragamo belts


kobe 9


coach factory outlet


adidas gazelle


canada goose jacket


cheap jordans


kd 11


reebok shoes


adidas yeezy


jordan shoes


replica rolex


longchamp handbags


jordan shoes


golden goose outlet


stephen curry 5


yeezy boost


yeezy boost 350 v2


golden goose


nike flyknit racer


yeezy


michael jordan shoes


jordan shoes


golden goose outlet


chrome hearts online


nike react


kd shoes


goyard handbags


louboutin shoes


lebron 16 shoes


yeezy boost 350


ysl


converse outlet


michael kors outlet


nike epic react


gucci belt


mlb jerseys


goyard bags


chrome hearts


nike sneakers for men


qzyfffff

2018-12-28 오후 5:52:21
d qzyfffff

kobe 9


reebok outlet


adidas outlet online


red bottom heels


golden goose


golden goose sneakers


nike air max 270


pandora bracelet


links of london outlet store


yeezy boost 350


jordan 6


ferragamo belts


kobe 9


coach factory outlet


adidas gazelle


canada goose jacket


cheap jordans


kd 11


reebok shoes


adidas yeezy


jordan shoes


replica rolex


longchamp handbags


jordan shoes


golden goose outlet


stephen curry 5


yeezy boost


yeezy boost 350 v2


golden goose


nike flyknit racer


yeezy


michael jordan shoes


jordan shoes


golden goose outlet


chrome hearts online


nike react


kd shoes


goyard handbags


louboutin shoes


lebron 16 shoes


yeezy boost 350


ysl


converse outlet


michael kors outlet


nike epic react


gucci belt


mlb jerseys


goyard bags


chrome hearts


nike sneakers for men


qzyfffff

2018-12-28 오후 5:53:49
※ 이 게시물에 대한 의견을 입력해 주세요(4,000자 이내).
엑셀연말정산자동계산
엑셀 2007 교육
워드프로세서 기출문제
컴퓨터활용 기출문제
2013년 급여 자동계산
단원별 기출문제 검색
엑셀자동화 서식
엑셀자동화 방법
엑셀실무 팁
두드림 통합 검색
엑셀자동화서식제작요청
상호 : 두드림기획 | 사업자등록번호 : 105-20-55088 | 통신판매업신고번호 : 마포통신 제5343호 | 대표 : 이형범 |
고객정보관리책임자 : 이소연 | 주소 : 서울특별시 마포구 월드컵로16길 47 201호(서교동) | 전화: 02)323-7705 |
Fax: 02)6918-4545 | 입금계좌 : 국민은행(543001-01-213514) | E-Mail :
Copyright 2006 두드림기획(www.edodream.com) All Rights Reseved.