Highlight a Section of a Chart

No video

Highlight a Section of a Chart

Рет қаралды 139,186

11 жыл бұрын

When you create charts, sometimes there are area you want to point out or put some focus on....or maybe just highlight! In this video, I'll show you how to highlight a section of a line chart by adding another series of data and using the area chart type.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Пікірлер: 32

@hcchew1 8 жыл бұрын

Cool! I need this, thank you very much~

@msantosh1220 4 жыл бұрын

Thankx Doug for keep this video simple, Today I am going to use this same tips in my chart for presentation.

@DougHExcel 4 жыл бұрын

Thanks Santosh Mekale, glad it helped!

@Lazarus2k4 4 жыл бұрын

Doug this is phenomenal. Thank you thank you thank you.

@DougHExcel 4 жыл бұрын

Glad you enjoyed it!

@ranjitjojo 11 жыл бұрын

Thank you doug

@saravananganesan9570 8 жыл бұрын

this is really awesome. thank you.

@DougHExcel 3 жыл бұрын

Hi saravanan ganesan, thanks for the comment!

@Karthik-ut3vo 2 жыл бұрын

How to highlight the section of chart both in Vertical(as shown in this video) and Horizontal?

@chordc1699 4 жыл бұрын

Appreciate the help buddy, hope you are doing well

@DougHExcel 4 жыл бұрын

Thanks, you too!

@alexrosen8762 7 жыл бұрын

Perfect. Thanks!

@DougHExcel 7 жыл бұрын

Thanks!

@alexrosen8762 7 жыл бұрын

Is it possible to also make a dashboard tutorial?

@danadrakulich9061 3 жыл бұрын

Thank you!!!!!

@DougHExcel 3 жыл бұрын

You're welcome!

@basitnazir1631 7 жыл бұрын

thank you

@DougHExcel 7 жыл бұрын

You're Welcome!

@Invisible_017 2 жыл бұрын

8 years later and THANK YOU!!!!!!!!!

@DougHExcel 2 жыл бұрын

Hi Alex Invisible, you're welcome!

@Sarah-og3mp 2 жыл бұрын

I know this is an extremely old video and you probably won't answer, but when i try to copy and paste a column of data to a chart, it shows up when i hover over paste but disappears from the chart when i click it. When i try adding it by right clicking add data my first set of data gets all messed up and shoved on 1 vertical line. Any ideas?

@sahil2281 Жыл бұрын

If my x axis is time in hours and minutes how would i highlight the region between two times. For example highlighting the region between 03:43 and 07:51 for example?

@gur0106 3 жыл бұрын

Thanks a lot Doug. Does it work if I have multiple lines(data) in the chart e.g. sales, expenses and Profit by months? For some reasons I am not able to do it..

@DougHExcel 3 жыл бұрын

maybe something like this? kzfaq.info/get/bejne/f7Z4lbqGptaqmJ8.html

@cvideos9641 3 жыл бұрын

My second chat does not line up correctly on the x-axis. and when I change it to an area chart, it changes both the original line chart and the new data points to an area chart. Any suggestions are appreciated.

@DougHExcel 3 жыл бұрын

Hi CVideos, thanks for the comment! Check if the 2nd Y axis min and max values are the same as the 1st Y axis.

@marketmatters3815 5 жыл бұрын

Slightly different in Office 365. Need to setup as a combo. Change the selected Series # to area

@DougHExcel 3 жыл бұрын

Hi Market Matters, thanks for the comment!

@michaelbailey6917 2 жыл бұрын

This does not work on large data sets

@kharma1111 11 жыл бұрын

You lost me when you changed the sales to 900. I don't see how a reader would know what the 900 stood for since the sales don't go that high. I think they would be confused unless you meant to change the sales data as well