Как построить гистограмму в Эксель

Программа Microsoft Office Excel – это табличный редактор с широкими возможностями. Некоторые пользователи данной программы сталкиваются с необходимостью отобразить числовые значения в виде графиков. В приложении Excel есть такая возможность, все данные в таблице можно представить в виде гистограммы. Для этого вам понадобится:

— Персональный компьютер или ноутбук(Закажите компьютер под ваши нужды в нашем интернет-магазине, цены и условия можно узнать здесь);

— Программа Microsoft Office Excel.

Инструкция

  1. Откройте программу Excel и внесите в таблицу данные, по которым нужно отобразить гистограмму.
  2. Выделите одну из ячеек с данными и вызовите меню «Вставка», в нем найдите и выберите пункт «Диаграмма». Также вы можете приступить к созданию гистограммы, нажав на кнопку «Мастер диаграмм» на стандартной панели инструментов или нажав «горячую клавишу» F11.
  3. В появившемся окне укажите тип «Гистограмма», теперь в группе «Вид» необходимо обозначить подтип данной гистограммы. Обратите внимание на подсказки, они помогут сделать правильный выбор.
    Вставка гистограммы
    Вставка гистограммы

    Для предварительного просмотра используйте команду «Результат». Для создания своеобразной и более сложной гистограммы, перейдите на дополнительную вкладку «Нестандартные». После выбора вида кликните кнопку «Далее».

  4. Теперь на экране появится диалоговое окно, в нем нужно указать ячейки с данными, из которых будет состоять гистограмма. Введите требуемые значения в строку «Диапазон». Также в данном окне имеется переключатель «Ряды в»,
    Указание диапазона данных
    Указание диапазона данных

    с помощью него укажите какие значения будут расположены на осях абсцисса и ордината соответственно. После введения всех нужных данных нажмите на кнопку «Далее».

  5. В открытом диалоговом окне «Параметры гистограммы» перейдите на вкладку «Заголовки», на данной вкладке можно присвоить имена осей, если вам это не нужно, то можете оставлять поля пустые. Просмотрите все имеющиеся вкладки в данном окне, на них можно привести гистограмму к нужному для вас виду. При совершении каких-либо изменений с внешним видом графика, все они будут отображаться в окне предварительного просмотра. После присвоения нужного вида гистограмме кликните кнопку «Далее».
  6. Откроется последнее окно в создании гистограммы. В данном окне нужно указать место, в котором будет отображаться созданный график. Гистограмма может располагаться как на текущем листе, так и на отдельном. После выполнения всех указанных действий нажмите на кнопку «Готово». Гистограмма будет отображена в указанном месте.

Видео: Как построить гистограмму в Excel

Сергей Гришечкин

Главный редактор информационного портала BestHard.

sergey2829 имеет 750 сообщений и подсчета голосов.Посмотреть все сообщения sergey2829

129 thoughts on “Как построить гистограмму в Эксель

  • 14.05.2019 в 06:24
    Permalink

    I am really grateful to the holder of this web site who has shared this great piece of writing at at this place.

    Ответ
  • 18.05.2019 в 14:00
    Permalink

    A fascinating discussion is worth comment. There’s no doubt that that
    you should write more on this subject matter,
    it might not be a taboo subject but generally people don’t talk about such issues.
    To the next! Kind regards!!

    Ответ
  • 20.05.2019 в 15:45
    Permalink

    Howdy just wanted to give you a quick heads up and let you know a few
    of the pictures aren’t loading correctly. I’m not
    sure why but I think its a linking issue.
    I’ve tried it in two different web browsers and both show the
    same results.

    Ответ
  • 02.06.2019 в 20:45
    Permalink

    Hello! I simply wish to give you a big thumbs up for your excellent information you have
    got right here on this post. I’ll be coming back to your blog for more
    soon.

    Ответ
  • 05.06.2019 в 09:02
    Permalink

    Keep up the wonderful work, I read few posts on this site and I believe that your site is real interesting and contains sets of
    excellent information.

    Ответ
  • 06.06.2019 в 08:10
    Permalink

    Hi there Dear, are you in fact visiting this site on a
    regular basis, if so after that you will absolutely get good experience.

    Ответ
  • 11.06.2019 в 04:10
    Permalink

    I enjoy what you guys are usually up too. This type of clever work and
    exposure! Keep up the awesome works guys I’ve included you guys to blogroll.

    Ответ
  • 11.06.2019 в 11:24
    Permalink

    I like what you guys are up too. Such clever work and reporting!
    Keep up the excellent works guys I have incorporated you guys to my blogroll.
    I think it’ll improve the value of my web site
    :).

    Ответ
  • 11.06.2019 в 17:36
    Permalink

    Hello mates, nice article and fastidious urging commented at this place, I am
    in fact enjoying by these.

    Ответ
  • 14.06.2019 в 05:00
    Permalink

    Terrific article! That is the kind of information that are meant
    to be shared around the web. Disgrace on the search engines for not positioning
    this post upper! Come on over and consult with my site .
    Thanks =)

    Ответ
  • 14.06.2019 в 06:06
    Permalink

    I think everything published was very logical. However, what about this?
    what if you were to write a awesome title? I am not suggesting your
    information isn’t good, but what if you added a headline that
    makes people want more? I mean Пошаговая инструкция: Как построить гистограмму в
    Эксель is a little boring. You might look at Yahoo’s home page
    and see how they create article headlines to grab viewers to click.
    You might try adding a video or a picture or two to grab people excited about what you’ve written. Just my opinion,
    it might make your posts a little livelier.

    Ответ
  • 14.06.2019 в 06:13
    Permalink

    Keep up the fantastic piece of work, I read
    few content on this internet site and I believe that your website is real
    interesting and has got sets of fantastic info.

    Ответ
  • 14.06.2019 в 07:02
    Permalink

    As I web-site possessor I believe the content matter here
    is rattling great , appreciate it for your efforts.
    You should keep it up forever! Best of luck.

    Ответ
  • 14.06.2019 в 10:04
    Permalink

    Hello There. I found your blog using msn. This is a really well written article.
    I’ll be sure to bookmark it and come back to read more
    of your useful information. Thanks for the post.
    I’ll certainly comeback.

    Ответ
  • 18.06.2019 в 01:21
    Permalink

    Hello! Someone in my Myspace group shared this website with us so I came to check it out.
    I’m definitely enjoying the information. I’m bookmarking and will be tweeting this to my followers!
    Wonderful blog and great style and design.

    Ответ
  • 18.06.2019 в 08:04
    Permalink

    What you published made a lot of sense.
    However, what about this? suppose you typed a catchier post
    title? I ain’t suggesting your content is not solid., however what if
    you added a title that makes people desire more?
    I mean Пошаговая инструкция: Как построить гистограмму в Эксель is a
    little boring. You ought to glance at Yahoo’s front page and see how they write post headlines to get viewers to open the links.
    You might add a video or a picture or two to grab
    people excited about what you’ve got to say. Just
    my opinion, it might make your posts a little livelier.

    Ответ
  • 18.06.2019 в 08:10
    Permalink

    Hello There. I found your blog using msn. This is a really well
    written article. I’ll be sure to bookmark it and come back to read more
    of your useful information. Thanks for the post. I’ll definitely comeback.

    Ответ
  • 18.06.2019 в 17:27
    Permalink

    I like what you guys are usually up too. This kind of clever work and exposure!
    Keep up the terrific works guys I’ve incorporated you guys
    to my own blogroll.

    Ответ
  • 19.06.2019 в 13:17
    Permalink

    Hiya very cool blog!! Guy .. Excellent .. Superb ..
    I will bookmark your site and take the feeds also?
    I’m happy to seek out so many helpful info here in the post,
    we need develop more techniques on this regard, thanks for sharing.
    . . . . .

    Ответ
  • 19.06.2019 в 23:27
    Permalink

    I like what you guys are up too. Such smart work and reporting!
    Carry on the superb works guys I have incorporated you
    guys to my blogroll. I think it will improve the value of my website :).

    Ответ
  • 20.06.2019 в 15:08
    Permalink

    You are my aspiration, I own few blogs and occasionally run out from brand :
    ).

    Ответ
  • 20.06.2019 в 15:23
    Permalink

    Hey very cool blog!! Man .. Beautiful .. Wonderful ..
    I will bookmark your web site and take the feeds additionally?
    I am happy to find numerous helpful info right here within the submit, we need develop extra strategies in this regard,
    thanks for sharing. . . . . .

    Ответ
  • 20.06.2019 в 15:26
    Permalink

    You are my inspiration, I have few web logs and very sporadically run out from post :).

    Ответ
  • 20.06.2019 в 18:33
    Permalink

    I don’t ordinarily comment but I gotta admit
    regards for the post on this amazing one :D.

    Ответ
  • 21.06.2019 в 04:57
    Permalink

    Great article! This is the type of information that should be
    shared across the net. Disgrace on the search engines for no longer positioning this publish upper!
    Come on over and seek advice from my site . Thanks =)

    Ответ
  • 21.06.2019 в 09:12
    Permalink

    At this time it looks like WordPress is the preferred blogging platform out there right now.

    (from what I’ve read) Is that what you are using on your
    blog?

    Ответ
  • 21.06.2019 в 10:57
    Permalink

    At this time it sounds like Drupal is the best blogging platform available right now.
    (from what I’ve read) Is that what you are using on your
    blog?

    Ответ
  • 21.06.2019 в 14:26
    Permalink

    I was just seeking this info for some time. After six hours of continuous Googleing, at last I
    got it in your website. I wonder what is the lack of Google strategy that don’t rank this kind of informative sites in top of the list.
    Normally the top websites are full of garbage.

    Ответ
  • 21.06.2019 в 19:41
    Permalink

    Hi there! Someone in my Myspace group shared this site with us
    so I came to look it over. I’m definitely enjoying the information. I’m book-marking and will be tweeting
    this to my followers! Wonderful blog and outstanding design.

    Ответ
  • 23.06.2019 в 06:48
    Permalink

    Great work! That is the kind of information that should be shared across the internet.
    Shame on the seek engines for no longer positioning
    this put up upper! Come on over and consult with my web site .
    Thank you =)

    Ответ
  • 23.06.2019 в 09:27
    Permalink

    Hello There. I found your blog using msn. This is an extremely well
    written article. I will make sure to bookmark it and come back to read more of
    your useful info. Thanks for the post. I will definitely comeback.

    Ответ
  • 23.06.2019 в 10:31
    Permalink

    I was just seeking this information for a while. After 6 hours of continuous Googleing,
    at last I got it in your web site. I wonder what’s the lack of Google strategy that do not rank
    this kind of informative web sites in top of the list.
    Usually the top web sites are full of garbage.

    Ответ
  • 23.06.2019 в 18:12
    Permalink

    I believe what you composed was actually very logical.
    But, what about this? suppose you were to create a killer headline?
    I ain’t suggesting your information isn’t solid, but suppose you added
    a post title to possibly get folk’s attention? I mean Пошаговая инструкция: Как построить гистограмму в
    Эксель is a little boring. You ought to look at Yahoo’s front page and watch how they
    create article headlines to get viewers to open the
    links. You might try adding a video or a related pic or two to grab readers
    interested about what you’ve written. In my opinion,
    it could bring your posts a little livelier.

    Ответ
  • 23.06.2019 в 19:12
    Permalink

    I was just searching for this info for a while.
    After six hours of continuous Googleing, finally I got it in your web site.
    I wonder what’s the lack of Google strategy that
    don’t rank this kind of informative web sites in top of the list.
    Generally the top websites are full of garbage.

    Ответ
  • 24.06.2019 в 12:23
    Permalink

    Good day very cool web site!! Man .. Excellent .. Amazing ..
    I will bookmark your website and take the feeds additionally?
    I am happy to seek out a lot of useful information right here in the submit,
    we’d like work out more techniques in this regard, thank you
    for sharing. . . . . .

    Ответ
  • 24.06.2019 в 23:01
    Permalink

    Howdy! Someone in my Facebook group shared this site with us
    so I came to give it a look. I’m definitely loving the information. I’m
    book-marking and will be tweeting this to my followers!
    Superb blog and great design.

    Ответ
  • 25.06.2019 в 04:30
    Permalink

    Wonderful work! This is the type of information that are meant
    to be shared around the web. Disgrace on the seek engines for no longer positioning this publish higher!
    Come on over and seek advice from my website . Thank you =)

    Ответ
  • 25.06.2019 в 14:39
    Permalink

    What’s up colleagues, nice post and good urging commented here, I
    am really enjoying by these.

    Ответ
  • 25.06.2019 в 22:20
    Permalink

    I loved as much as you’ll receive carried out proper here.
    The sketch is attractive, your authored material stylish.
    nevertheless, you command get bought an edginess over that you wish be delivering the following.

    sick unquestionably come further earlier once more as exactly
    the similar nearly very frequently inside case you shield this hike.

    Ответ
  • 26.06.2019 в 06:30
    Permalink

    I really love your website.. Very nice colors & theme.

    Did you create this amazing site yourself?
    Please reply back as I’m hoping to create my own website and want
    to know where you got this from or exactly what the theme
    is named. Appreciate it!

    Ответ
  • 26.06.2019 в 06:59
    Permalink

    Hi there friends, fastidious paragraph and pleasant arguments
    commented here, I am genuinely enjoying by these.

    Ответ
  • 26.06.2019 в 07:08
    Permalink

    Keep up the good work, I read few posts on this website and I think
    that your web blog is very interesting and has circles of excellent information.

    Ответ
  • 26.06.2019 в 10:02
    Permalink

    I was just searching for this information for some time.
    After six hours of continuous Googleing, at last I got it
    in your website. I wonder what is the lack of Google strategy that do not rank this
    type of informative web sites in top of the list. Generally the top web sites are full of
    garbage.

    Ответ
  • 27.06.2019 в 16:07
    Permalink

    Keep up the excellent work, I read few content on this web site and I conceive that your blog is rattling interesting and has got sets of
    excellent information.

    Ответ
  • 27.06.2019 в 17:44
    Permalink

    I believe what you typed made a bunch of sense. But, what
    about this? suppose you typed a catchier title?
    I ain’t saying your content is not good, but what if you added a
    title that grabbed people’s attention? I mean Пошаговая
    инструкция: Как построить гистограмму в Эксель is
    a little plain. You ought to look at Yahoo’s home page and see how they create news
    headlines to get people to open the links. You might try adding a video or a pic or two to grab people excited about what you’ve
    got to say. In my opinion, it might make your blog a little bit
    more interesting.

    Ответ
  • 30.06.2019 в 15:50
    Permalink

    What you posted was actually very logical. But,
    what about this? what if you added a little information? I mean, I don’t want to tell you
    how to run your blog, but what if you added a
    title that makes people want more? I mean Пошаговая
    инструкция: Как построить гистограмму в
    Эксель is a little plain. You ought to glance at Yahoo’s front page
    and watch how they create post titles to get viewers interested.
    You might add a video or a picture or two to grab readers excited about everything’ve got to say.
    Just my opinion, it might make your posts a little bit more
    interesting.

    Ответ
  • 30.06.2019 в 16:40
    Permalink

    Hi there friends, nice piece of writing and nice arguments
    commented at this place, I am actually enjoying by these.

    Ответ
  • 02.07.2019 в 00:36
    Permalink

    As I website possessor I believe the content material here is rattling fantastic
    , appreciate it for your efforts. You should keep it up forever!
    Best of luck.

    Ответ
  • 02.07.2019 в 18:58
    Permalink

    I liked up to you will obtain carried out right here. The cartoon is tasteful, your
    authored subject matter stylish. nonetheless, you command
    get bought an impatience over that you want be delivering the following.
    unwell for sure come more until now again since exactly the similar just about a lot
    continuously inside case you shield this hike.

    Ответ
  • 04.07.2019 в 04:27
    Permalink

    You are my inhalation, I own few web logs and occasionally run out from
    post :).

    Ответ
  • 05.07.2019 в 10:36
    Permalink

    I was just seeking this information for some time.
    After six hours of continuous Googleing, at last I got it in your site.

    I wonder what’s the lack of Google strategy that don’t rank this kind of
    informative web sites in top of the list. Generally the top websites are full of garbage.

    Ответ
  • 06.07.2019 в 01:03
    Permalink

    As I web-site possessor I believe the content material here is rattling
    fantastic , appreciate it for your hard work. You should keep it
    up forever! Best of luck.

    Ответ
  • 06.07.2019 в 05:33
    Permalink

    As I web-site possessor I believe the content material here is
    rattling great , appreciate it for your hard work. You should keep it up forever!
    Best of luck.

    Ответ
  • 06.07.2019 в 14:35
    Permalink

    Keep up the fantastic work, I read few articles on this web
    site and I conceive that your web blog is really interesting and contains lots of good information.

    Ответ
  • 10.07.2019 в 01:13
    Permalink

    Hey there! Someone in my Facebook group shared this website with us so I came to give it a
    look. I’m definitely loving the information. I’m book-marking and will be tweeting this to my followers!

    Terrific blog and excellent design and style.

    Ответ
  • 10.07.2019 в 04:34
    Permalink

    As I website possessor I believe the content material here is rattling great , appreciate it for your
    hard work. You should keep it up forever! Good Luck.

    Ответ
  • 15.07.2019 в 08:35
    Permalink

    As I site possessor I believe the content material here is rattling magnificent ,
    appreciate it for your efforts. You should keep it up forever!
    Best of luck.

    Ответ
  • 15.07.2019 в 16:02
    Permalink

    As I web site possessor I believe the content matter here is rattling
    excellent , appreciate it for your hard work. You should keep it up forever!
    Best of luck.

    Ответ
  • 15.07.2019 в 23:48
    Permalink

    Hi there colleagues, fastidious piece of writing and nice arguments commented at
    this place, I am actually enjoying by these.

    Ответ
  • 16.07.2019 в 00:20
    Permalink

    I beloved up to you’ll receive carried out proper here.

    The sketch is tasteful, your authored material stylish.
    nonetheless, you command get bought an shakiness over that you wish be delivering the following.
    ill unquestionably come further before again as exactly the same just about very
    incessantly inside of case you protect this hike.

    Ответ
  • 16.07.2019 в 06:32
    Permalink

    wonderful issues altogether, you simply won a brand new reader.
    What may you suggest about your put up that you simply made some days ago?
    Any positive?

    Ответ
  • 16.07.2019 в 18:37
    Permalink

    Hi friends, nice article and good urging commented at this place,
    I am really enjoying by these.

    Ответ
  • 16.07.2019 в 19:24
    Permalink

    As I web site possessor I believe the content matter here is rattling fantastic , appreciate
    it for your hard work. You should keep it up forever!
    Best of luck.

    Ответ
  • 17.07.2019 в 00:43
    Permalink

    Hello mates, nice article and nice urging commented here, I
    am really enjoying by these.

    Ответ
  • 17.07.2019 в 01:36
    Permalink

    I truly love your site.. Great colors & theme. Did you develop this website yourself?

    Please reply back as I’m wanting to create my very own site and want to find out where you got
    this from or what the theme is named. Many thanks!

    Ответ
  • 17.07.2019 в 05:39
    Permalink

    I liked as much as you will obtain carried out right here. The comic strip is attractive,
    your authored material stylish. nonetheless, you command get
    bought an edginess over that you want be handing over the following.
    sick undoubtedly come more previously once more as exactly the similar nearly a lot frequently inside case you
    shield this increase.

    Ответ
  • 17.07.2019 в 09:11
    Permalink

    I enjoy what you guys are usually up too. This type of clever work
    and reporting! Keep up the very good works guys I’ve you guys to my personal blogroll.

    Ответ
  • 17.07.2019 в 09:51
    Permalink

    Wow, that’s what I was searching for, what a information! present here
    at this website, thanks admin of this website.

    Ответ
  • 17.07.2019 в 10:55
    Permalink

    It’s a shame you don’t have a donate button! I’d definitely donate to this brilliant
    blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account.
    I look forward to fresh updates and will talk about this blog with
    my Facebook group. Chat soon!

    Ответ
  • 17.07.2019 в 14:55
    Permalink

    Everyone loves it when folks come together and share opinions.
    Great site, stick with it!

    Ответ
  • 17.07.2019 в 16:28
    Permalink

    Hi there Dear, are you actually visiting this web
    site on a regular basis, if so after that you
    will absolutely obtain fastidious knowledge.

    Ответ
  • 18.07.2019 в 01:14
    Permalink

    I don’t know if it’s just me or if everyone else encountering problems with your website.

    It appears as though some of the text within your content are running off the screen. Can someone else
    please provide feedback and let me know if this is happening to them as well?

    This may be a issue with my web browser because I’ve had this
    happen previously. Thanks

    Ответ
  • 18.07.2019 в 16:28
    Permalink

    Just wish to say your article is as astonishing.

    The clarity in your post is just cool and i could assume you’re
    an expert on this subject. Well with your permission let me to grab your RSS feed
    to keep up to date with forthcoming post. Thanks a million and please continue the enjoyable work.

    Ответ
  • 18.07.2019 в 21:07
    Permalink

    I believe what you said made a great deal of sense.
    But, what about this? what if you typed a catchier title?
    I am not suggesting your information isn’t solid, however what if you
    added a post title that grabbed people’s attention? I
    mean Пошаговая инструкция: Как построить гистограмму в Эксель is a little boring.
    You could peek at Yahoo’s home page and note how they create news headlines to get
    people interested. You might try adding a video
    or a related picture or two to get readers excited about what you’ve got to say.
    Just my opinion, it might make your website a little livelier.

    Ответ
  • 18.07.2019 в 21:31
    Permalink

    Hello There. I found your blog using msn. This is a really
    well written article. I’ll be sure to bookmark it and return to read more of your useful
    information. Thanks for the post. I will certainly return.

    Ответ
  • 18.07.2019 в 22:04
    Permalink

    Hiya very nice site!! Man .. Excellent .. Amazing ..

    I’ll bookmark your website and take the feeds additionally?

    I am glad to find numerous helpful information right
    here in the publish, we want work out more strategies on this regard, thanks for sharing.
    . . . . .

    Ответ
  • 19.07.2019 в 16:53
    Permalink

    Pretty nice post. I just stumbled upon your weblog and wanted to say that I have truly enjoyed browsing
    your blog posts. In any case I will be subscribing to your rss feed
    and I hope you write again soon!

    Ответ
  • 20.07.2019 в 09:47
    Permalink

    I was very pleased to find this web site.
    I want to to thank you for your time for this particularly fantastic read!!
    I definitely really liked every part of it and I have you saved to fav to look at new things on your site.

    Ответ
  • 21.07.2019 в 10:43
    Permalink

    Hello, i read your blog occasionally and i own a similar one and i was just
    curious if you get a lot of spam feedback? If so how do you stop it,
    any plugin or anything you can suggest? I get so much lately
    it’s driving me crazy so any help is very much appreciated.

    Ответ
  • 22.07.2019 в 06:04
    Permalink

    These are truly wonderful ideas in concerning blogging.
    You have touched some good factors here. Any way keep up wrinting.

    Ответ
  • 22.07.2019 в 13:09
    Permalink

    Good day I am so thrilled I found your webpage, I really found you by mistake,
    while I was looking on Digg for something else, Nonetheless I am here now and would just like to say many thanks for
    a tremendous post and a all round exciting blog
    (I also love the theme/design), I don’t have time to go through it all at the moment but I
    have saved it and also added your RSS feeds, so when I have time I
    will be back to read a great deal more, Please do keep up the awesome work.

    Ответ

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *