Learn the basics of Excel charts to be able to quickly create graphs for your Excel reports.
Written instructions: http://www.xelplus.com/charts-basics/
In this video you’ll learn:
1. How to insert an Excel Chart
2. How to adjust a chart (edit the chart)
3. How to improve a chart
4. How to add series to a chart
5. How to create combination charts (charts that show more than one variable – or multiple data sets) – for example how to combine a column chart with a line chart.
The type of Excel charts covered are column, bar, line and a combination of column and line chart. Use these charts to make comparisons or show trends.
★★ Links to related videos: ★★
Chart Playlist on YouTube ► https://www.youtube.com/playlist?list=PLmHVyfmcRKyyEj7oQkCf7TL9yQQWXbGOQ
Using shapes in charts (non-standard graphs)► https://youtu.be/C9beIaL-cBA
➹ ➹ ➹ Online Excel Courses ➹ ➹ ➹
Excel VBA & Macros ► http://bit.ly/LeilaVBA
Excel Dashboards ► http://bit.ly/LeilaDashboards
Excel Charts ► http://bit.ly/LeilaCharts
Advanced Excel ► http://bit.ly/LeilaAdvancedExcel
Excel Waterfall Charts ► http://bit.ly/LeilaWaterfall
🕮 Recommend Excel Resources 🕮
https://www.xelplus.com/resources/
✉ Subscribe to my Newsletter ✉
Stay informed and get discounts when new courses come out: https://www.xelplus.com/subscribe/
Price:
Good Charts: The HBR Guide to Making Smarter, More Persuasive Data Visualizations
(224)
Price: $26.96
Polyvagal Flip Chart: Understanding the Science of Safety (Norton Series on Interpersonal Neurobiology)
(as of November 16, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $0.00
OsmAnd Nautical Charts
graphical representation of oceans, seas, coastal areas and rivers information about sailing routes, navigation lights, dangerous areas (as of November 16, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Price: $46.67
![Beginner’s Guide to Excel – Excel Basics Tutorial – [2018 Edition]](https://img.youtube.com/vi/ltMHxWCPDd8/0.jpg "Beginner’s Guide to Excel – Excel Basics Tutorial – [2018 Edition]")
Thank u so much Ms. Leila it was really really useful and I’ve learned a lot from it waiting the next video hhh
Many, Many Thanks Leila! it was wonderful. Thanks for sharing.
Thanks for your videos, just featured several of them here:
http://radupopa.co/free-excel-online-course/
Very informative…… easy to learn….Thank u
Thank You So Much!!!.. The concept you are explaining is very clear in each video!! Keep doing the Good Work !! We are looking forward to your upcoming New concepts!!!
Hi Leila – can you show some techniques on how to graph disparate values (i.e. 100 million vs 100 thousand) and how to graph negative and positive values in one chart horizontally like a bar chart instead of vertically like a column chart.
Great chart tools and insights Leila
very nice effort. it is much useful for my work. thanks a lot dear Leila Gharani . stay blessed. i am from lahore, pakistan.
Hello, I have a issue that I hope you can help me with. It may be easier to give you the file, but I will attempt to explain it here. You may also tell me that a Pivot Table or some other option will give me what I want, I have not learned them at this time.
Ok, on the first tab (call it Data A) I have raw data on lines. At this point I can use “=MIN(D1:D50)” to find the Minimum value in a column. Even if some of the cells are blank it looks past them and only finds a real number
Ok, on a second tab I want only some parts of the data, so I have some thing like this “=’Data A’!b3” and I get what ever the data is on “Data A” tab in this cell. This works a I expect. But when the referenced cell is BLANK it does not bring over a BLANK cell to the second tab. It puts a “0” in the tab. At this point on the second tab if I again use “=MIN(D1:D50)” it now sees the “0” and my formula returns a “0”. I want it to bring over the BLANK or Empty Cell
James
Great tutorial indeed. Once again no words to explain your good deeds, BIG & VERY BIG ROYAL SALUTE TO YOU MADAM. Waiting eagerly to learn more and more in the days to come. We are very lucky indeed to get a great teacher/guru in Excel like you, which no one can compete. Yours greatest admirer/follower/disciple – Gopalakrishna
Hi Leila, would you please to create more videos related to ms excel 2016 graph. I like to prepare the dashboard reporting, so I can improve it. Thank you. It’s awesome your video tutorial.
How do you insert text into a text box? For example, how do I import a file that has text into a text box? Do I just copy and paste or is there another way to input file where the information will appear into the text box without copy and pasting? Please help.
What about if my chart don’t show me the freaking green cross
Thank You Very Much!!!..
Nice video but volume is too low
thank you – very simply done and detailed.
Why does a woman know how to use a excel?
Great top tips, generally at work due to time constraints, I normally just knock a quick chart up from self taught learning, very ad hoc and messy.
Not any more after watching this great video.
Thanks Darren
Hi Leila, can you make tutorial on create table ? How would help user quickly setting etc..
Hi , I am working on a chart and I can’t disclose any information here.. but I really need some help with creating an interactive chart, I’ve literally went through all the videos i could get my hand on , but its not helping my case. Can i ask you email ID so that I can explain the issue better?
Thanks.
Hey nice job – thanks!
Are there any specific chart topics you’d like me to cover? Let me know in the comments below.
Thanks for this tutorial – very helpful information.
Thank you
Thanks
Any link to download excel 2016 along with key ??
Ms. Thanks for teaching a great things for beginner, I’m just learning for u n others teachers thru ytube which are very essential for me to work in the office, pls advise how i ll get the sign of plus n filter the other mark beside of the graphs when u click the plus the chart elements show, pls advise
Excellent! Thanks very much for the video….
I think this is a great training video for beginners like me! Thank you!
There are other great tools you can use to make charts faster. I use Infogram because I can create those graphs in minutes. And it’s free. Try if you want – https://infogram.com/
thanks leila
I love it as always.
Just to say you Leila that I am your Fan and your student number one, thanks to teach Excel
This was an excellent presentation.
as usual this has been a very good video leila, thanks a lot!
Very useful. Thanks alot 🙂
Good videos. I can improving my skills. Thank you.
I love this Chart Leila to use for ActualVsBudget.But I am unable to use the bar chat with markers when budget is less than actual. Its becoming messy. Do you have any clever trick to overcome this type of chart where budget is less than actual sale? Just a thought!!!
Your really pretty. Video was really helpful and easy to understand and follow. Thank you 🙂
Thanks Leila, I would have preferred Executive Excel Dashboard.
Congratulation for winning the Most Valuable Professional (MVP) award from Microsoft.
Thank you for your valuable sharing on Excel which I benefited from it tremendously.
Once again, thank you and Congratulation.
Very good presentation. I love the way you teach it.