Přeskočit navigaci | Přeskočit na novinky
     

Jste zde: Úvodní stránka » excel » articles-in-english » special-graphs-charts-in-excel

20. Special charts (graphs) in Excel

Videokurzy Excel

Ve spolupráci se SEDUO jsem vytvořil několik videokurzů:

How to create special graphs or charts in Excel, whith free example.

special graphs - all

Introduction to special graphs

In the Microsoft Excel is a set of defined charts, but simple change you can create many derivative and special charts, practical examples in this article.

Quick overview graphs in this article.

  • 1. Waterfall chart
  • 2. Thermometer
  • 3. Special overlay
  • 4. Ghantt chart
  • 5. Analogue Clock from X/Y Chart
  • 6. Speedometer tachometer chart
  • 7. Double column chart
  • 8. Mirror chart
  • 9. Chart with picture
  • 10. Pareto chart
  • 11. Groups double bar charts
  • 12. Double Bar charts
  • 13. Conditional colors for chart
  • 14. Combination Area and Line charts
  • 15. Bar charts whith note
  • 16. Line charts whith limits
  • 17. Line charts whit area charts
  • 18. Double column charts
  • 19. Column charts whith limits
  • 20. Dynamic area for graph

1. Waterfall chart

special graphs - Waterfall chart

Works for negative values too.

Free Download

File Waterfall chart - example file *.xls to free download.


2. Thermometer

special graphs - thermometer

Free Download

File Thermometer - example file *.xls to free download.


3. Special overlay graph

special graphs

Free Download

File Special overlay - example file *.xls to free download.


4. Ghantt chart

special graphs Ghantt chart

Free Download

File Ghantt chart example file *.xlsx to free download.

Note:

Ghantt chart with conditional formatting


5. Analogue Clock from X/Y Chart

special graphs Analogue Clock from X/Y Chart

Analogue clock using an X/Y Chart.

Free Download

File Analogue Clock whith xy chart file *.xlsx to free download. (without VBA)


6. Speedometer tachometer chart

special graphs Speedometer tachometer chart

Donut Chart series and XY (Scatter) Chart.

Free Download

File Speedometer tachometer chart file *.xls to free download.


7. Double column chart

special graphs

Free Download

File Double column chart - example file *.xls to free download.


8. Mirror chart

special graphs Mirror chart

Free Download

File Mirror chart example file *.xls to free download.


9. Chart with picture

special graphs Chart with picture

Free Download

File Chart with picture - example file *.xls to free download.


10. Pareto chart

special graphs Pareto chart

Free Download

File Pareto chart - example file *.xls to free download.


11. Groups double bar charts

special graphs Groups double bar charts

Free Download

File Groups double bar charts - example file *.xls to free download.


12. Double Bar charts

special graphs Double Bar charts

Free Download

File Double Bar charts - example file *.xls to free download.


13. Conditional colors for chart

special graphs Conditional colors for chart

Free Download

File Conditional colors for chart - example file *.xls to free download.


14. Combination Area and Line charts

special graphs Combination Area and Line charts

Free Download

File Combination Area and Line charts - example file *.xls to free download.


15. Bar charts whith note

special graphs Bar charts whith note

Free Download

File Bar charts whith note - example file *.xls to free download.


16. Line charts whith limits

special graphs Line charts whith limits

Free Download

File Line charts whith limits - example file *.xls to free download.


17. Line charts whit area charts

special graphs Line charts whit area charts

Free Download

File Line charts whit area charts - example file *.xls to free download.


18. Double column charts

special graphs Double column charts

Free Download

File Double column charts - example file *.xls to free download.


19. Column charts whith limits

special graphs Column charts whith limits

Free Download

File Column charts whith limits - example file *.xls to free download.


20. Dynamic area for graph

special graphs Dynamic area for graph

Free Download

File Dynamic area of for graph - example file *.xls to free download.


More in Czech language

More about charts in Czech language.

Článek byl aktualizován: 21.06.2017 09:32

Donate

For further development of this web site.

Thank you for donations.


Pavel Lasák - autor webu

Pavel Lasák

Microsoft Office (Word, Excel, PowerPoint) se věnuji od roku 2000 (od 2004 ne této doméně) - Roku 2017 jsem od Microsoft získal prestižní ocenění MVP (zatím jsem jediný z ČR v kategorií Excel). Své vědomosti a zkušenosti dávám k dispozici také na on-line videích pro SEDUO. Školím a konzultuji, učím na MUNI. Hlavně tvořím tento web. Je zde k dispozici přes 1.000 návodu, tipů a triků včetně stovek různých šablon, sešitů.

   Pavel Lasák LinkedIn Profil    Pavel Lasák Google+ Profil    Pavel Lasák facebook Profil    Pavel Lasák twitter Profil


Komentáře


Paul

Přidáno: 05.07.14 22:53

Thank you very much for supplying these excel graphs. I have been looking for this and yours are perfect. Well done!

Pavel Lasák

Přidáno: 14.07.14 22:27

To Paul: Thank you for your comment.

Vlad

Přidáno: 25.08.14 22:15

Pavel - you're genius. Thanks!!!!

Pavel Lasák

Přidáno: 28.08.14 17:41

To Vlad: Thank you! You're welcome!

Denis

Přidáno: 06.03.15 18:04

Hi Pavel, your graphs are absolutely top. Thank you very much for sharing them. It was very helpful for me. Denis

Sadanand

Přidáno: 14.04.15 19:15

Thank you

Evin

Přidáno: 02.05.15 22:19

Thank you, it was very helpful.

Barath

Přidáno: 29.05.15 10:51

Can you share a graph where it has volumes received/Closed in a bar chart version and in the same chart having Turn around time also

Abhilash

Přidáno: 08.06.15 09:12

Perfect ! A great one !

chain

Přidáno: 03.07.15 10:38

How to add up-down button on Thermometer Thank you verymuch

Lukáš

Přidáno: 09.07.15 10:17

10/04/2015 Díky za skvělé grafy.

Viney

Přidáno: 17.11.15 12:43

Great Job dear. Your graphs are among the best I have ever find.

Samanta

Přidáno: 22.12.15 23:05

Thank you, it was Great Job.

Ondra

Přidáno: 03.03.16 18:07

Dík. Jsi jednička.

Dinong

Přidáno: 19.04.16 13:29

Perfect. Great Job.

Pavel Lasák

Přidáno: 09.05.16 08:30

To all: Thank you! You're welcome!

Rahul Dhane

Přidáno: 15.06.16 13:01

Thank you, it was very helpful.

Dergin

Přidáno: 03.07.16 23:17

Excelent. Thanks.

Shabbir Ahmed Pasha

Přidáno: 26.07.16 15:00

Very much helpful.. JazakAllah

Irfan

Přidáno: 11.10.16 18:45

ThankYou Sir for your Help . Helped me a lot for my Job Task .







Sdílejte

Pomohl Vám návod?
Sdílejte na Facebooku, G+
LinkedIn...

Nové články


Newsletter

Přihlaste se odběru novinek a získejte:
Ebook zdarma -
10 kroků ke zvládnutí (Word, Excel, PowerPoint)
Šipka Kniha 3D Více o ebooku ...

TOPlist Licence Creative Commons webarchiv rss XML

Stránky o MS Office (Excel) produktu společnosti Microsoft. Neslouží jako technická podpora.
| Email na autora: pavel.lasak@gmail.com | Copyright © : Pavel Lasák 2004 - 2017 | 82485

Tento web zatím neprošel jazykovou korekturou. Beta verze redakčního systému.