Відео

That's true, Roger 😁

Thnx!

Thnx Garret! I don't know what you mean by secret to organise the legend?

@@rbxexcelvideos For instance, if I have, say 9 items in a legend for 9 data series, can I re-organize the items into two columns of 5 and 4 items and have a label for each column? Or do I have to convert to drawing objects to do that? Problem with that is the objects won't update if the chart is modified...

@GarretDuffy-k2w, you can change the size of the legend to rearrange the data series. Having a label for such a column in your legend is not possible...

Thnx, you're welcome!

Thnx!

Thnx!

Hi, you can only choose one color for the complete series. To add a color for a categorie you could add more data series with each its own color. You can also set the color for each bubble manually by selecting only that one bubble and set its color. To select only one bubble click a bubble to select the series and then click again on one of the bubbles to select only that bubble.

Thnx Manjeets!

Thnx!

Thnx!

Thnx!

Hi Sudar, i never tried but I assume that just adding a column with a fourth level will work the same as for three levels.

Thnx!

Thnx, Erik!

You're welcome, Donna!

Thnx!

Thnx!

Hi Finn! Easiest way to do this is by creating a helper column with the percentage difference and show that column (as value from cells) in the data labels of one of the data series.

Thnx Thomas, you are totally right! However, understanding the index and match is an important feature to develop your Excel skills so they can be used for other solutions.

Thnx Tibibari, your totally right! I already knew but can't change the video anymore.

Thnx for your question, Sarang! You need select the data labels, press ctrl+1 for chart option, go to the label options and check the right boxes. I think there are two boxes checked at the moment.

@@rbxexcelvideos very well understood. So kind of you for your explanation and prompt response.

No problem, you're welcome!

Never tried this with a pivot table. Formatting options are limited for pivot charts so i dont know. What do you mean by automatically?

Thnx Jullesz!

To extend the graph you can just add data undernauth the table and extend the ranges of the chart. Dont forget to extend all data series of the chart.

Thnx Alexandre!

Thnx!

Thnx!

Thnx Lena, i dont know what that problem is but the same can be done with a horizontal bar chart.

@@rbxexcelvideos thanx - I found out how to use the camera function to tilt the whole chart

Thnx Lena!

Thank you!

Thnx, Michael!

That's not good. Maybe you can share you're formula.

Hi Mostafahwafy, i dont know how this can be done in a pivot chart but in normal charts you can apply conditional formatting by adding a second data series on top of the first. See my other videos about charts with conditional formatting for more info.

Thnx, Majeed! I think when lower is better you can just switch the red and green colors?

Thanks a lot!

Thnx!

Thnx, Aicx!

Hi Ghuruba, for sure you can add multiple data series for one checkbox. But one checkbox can only be linked to one cel so you need to add more columns depending one the value in that specific cel.

@@rbxexcelvideos perfect I have done it . I had 7 graphs showing each dept for same stats now I have one graph with tick box for 7 depts showing the results !!!!!!! Thanks Subscribed !

You're welcome! Nice to hear that it al worked out!

Hi I am having one problem when I untick and tick another box the data labels are showing 0% for the data which is not selected and the only way I can get rid is by removing all data labels but I want to keep them as I don’t show the tables

@@rbxexcelvideos I have tried adding if error or not putting na in the formula but on the graph still shows 0% even custom format with #”” and several other variation but no joy

Thnx!

Thnx Rebellious!

Thnx, Niki!

Thnx Tina, your'e welcome!

Thnx Tina! It should be automatic. I think you should check if you selected the right range for data labels and used the right data series.

@@rbxexcelvideos thank you! I selected max series without the label Max1 and that fixed it

Super!

Thnx!

​@@rbxexcelvideos I will definitely watch more videos and try to replicate them. I saw your charts playlist and it made me excited to keep on learning. Thanks!

To be clear when my values are smaller than 45 so when I try to subtract 45 from the data in my east and west columns I get a negative value. Is the 45 a significant value? you don't really explain what that represents and why we need to use that value.

Thnx for your question! In this case you need to replace the 45 with a smaller value. The 45 is only to get a series for the round edges. You need to look for a right value to get nice round edges on your bars.

Thnx!

You could say that, yes😁

Thnx George, as far as I know conditional formatting in Excel charts is only possible by using multiple data series like I did in this video.

Never subscribed faster thanks bud

I tried before but it didn't work. I will try again soon.

Thnx Padraigin!

Thnx Shadman, I tried before but didn't work. I will see if I can make it work soon.