Line Graph with a Target Range in Excel

Рет қаралды 75,303

Computergaga

Күн бұрын

Пікірлер: 42

@salnaud8898 3 жыл бұрын

Simple, Short and clear. Thank you very much for the work presented. Really appreciate

@Computergaga 3 жыл бұрын

You're welcome, Sepehr.

@wayneedmondson1065 5 жыл бұрын

Hi Alan.. great chart trick.. love the use of multi data series to get different effects like this. Your explanation was clear and concise. I was able to build my own version immediately after viewing the tutorial. Thanks and Thumbs up!

@Computergaga 5 жыл бұрын

Thank you Wayne.

@judytan65 3 жыл бұрын

Thank you for the tutorial, it is clear and simple to understand and has been a big help! 👍

@Computergaga 2 жыл бұрын

Great to hear. Thanks!

@glennlangford5897 5 жыл бұрын

Another great idea, very well explained, thanks Alan

@Computergaga 5 жыл бұрын

Thank you Glenn.

@kisipsimon1392 2 жыл бұрын

thank you so much. just what I was looking for.

@Computergaga 2 жыл бұрын

Great! 👍

@fatemehezati5583 Жыл бұрын

Thanks a lot sir this video was absolutely helpful, I had no idea how to apply a target range in my graph. Really appreciate it 👌👌👌👍👍👍👍

@Computergaga Жыл бұрын

You're very welcome.

@eduardov9630 3 жыл бұрын

Awesome! It helped me a lot! Thanks!

@Computergaga 3 жыл бұрын

Fantastic 👍 Thank you, Eduardo.

@SpotlightImpact 2 жыл бұрын

Thanks for sharing! Cool combo tricks! 🔥🔥

@Computergaga 2 жыл бұрын

Thank you 😊 👍

@jeromyashcraft4571 5 жыл бұрын

Great video. Thank you

@Computergaga 5 жыл бұрын

Thank you Jeromy.

@entertainmentgalaxy971 5 жыл бұрын

Bravo... thanks for sharing

@Computergaga 5 жыл бұрын

You're welcome Haider.

@troypaddy5041 2 жыл бұрын

thank you so much this video was very helpful

@Computergaga 2 жыл бұрын

Glad it was helpful! 😀

@Dev_Bartwal 5 жыл бұрын

Respect for you sir Thanks to shearing this useful video

@Computergaga 5 жыл бұрын

You're very welcome.

@najibahmadi7705 2 жыл бұрын

Thanks for well description :)

@Computergaga 2 жыл бұрын

You're very welcome 👍

@PGt-hz4vg 3 жыл бұрын

very useful....keep it up👍

@Computergaga 3 жыл бұрын

Thank you 😊

@user-uz1vk1kc2l 2 жыл бұрын

It is useful!

@Computergaga 2 жыл бұрын

Glad to hear that!

@traceygreet6436 5 жыл бұрын

Hi Alan, Do you have a Basic Chart and Graph tutorial? I have never done one before and need to know it for my Business Course I am doing online. I only ask because you explain things so well.

@Computergaga 5 жыл бұрын

Hi Tracey, I have one on creating Radar charts and one on a Step chart. I don't have videos on the basics of common charts such as column, line and pie though. I have lessons for these on my Ultimate Excel course - Beginner to Expert.

@traceygreet6436 5 жыл бұрын

Thank you Alan, l will check it out, l am so happy to have found your channel 🤗

@Computergaga 5 жыл бұрын

Thank you Tracey. I hope you find what you need. You can contact me for help directly through the course also.

@monakhalid9286 2 жыл бұрын

Thank you for the tutorial, but i have a few ranges not one !

@simaobonvalot9141 3 жыл бұрын

Hey, Wondering if anyone can help me : How do I change the order of the X axis. My X axis has the values inverted. I want it to display left to right from cell 28 to cell 6 , but he is displaying from cell 6 to cell 28. How can I invert ?

@Computergaga 3 жыл бұрын

Double click the axis to open the options. In the Axis Options there is a check box to put the categories in reverse order

@simaobonvalot9141 3 жыл бұрын

@@Computergaga Thank you very much for the help and the video.

@Computergaga 3 жыл бұрын

No worries.

@mayankk2800 Жыл бұрын

how to do the same in google sheets

@Computergaga Жыл бұрын

Don't know. Probably very similar but don't use it enough.

@flyingsalmon 7 ай бұрын

WARNING: The gap width does not work when you have a date column (say, you're taking daily/weekly/monthly measures) where the values are entered as a date (e.g. 3/10/2023 or whatever your date format is)...then the gap width=0 setting in the series no longer "floods the area"; as a result you don't get a solid range bar across (only separated bars with gaps)...I think it should be considered a bug in Excel unless someone has a good reason why date differerence should forcibly cause a gap between bars. If you want a workaround, change the date values to a different format or label them as text. Hope it helps.