Dear Community,

My question is (I believe) very simple to answer, but somehow being pretty new to Excel I cannot figure out how to solve it. 

I want to create a (pie) chart based on multiple datas that are all in the same row, but different columns.

As you can see in the picture, I want to create a pie chart that shows me how my expenses, which are divided in 7 categories, are actually split. I tried to create it selecting the name of the category and its expense by holding cmd/crtl, but when I create the chart it only considers the “Food” category and its price. As you can see from the columns highlighted in green, I am actually selecting all those cells, but somehow it does not work.

I overcame the problem once by listing the categories and the prices in the same columns, but in different rows and it worked. But I cannot believe that it’s not possible if the datas are on the same row, there must be a way, right?!

I want to mention that I have a Mac and use Excel online, in case this influences it. 

I look forward to hearing from some expert 😉

Thank you in advance

​Dear Community,My question is (I believe) very simple to answer, but somehow being pretty new to Excel I cannot figure out how to solve it. I want to create a (pie) chart based on multiple datas that are all in the same row, but different columns.  As you can see in the picture, I want to create a pie chart that shows me how my expenses, which are divided in 7 categories, are actually split. I tried to create it selecting the name of the category and its expense by holding cmd/crtl, but when I create the chart it only considers the “Food” category and its price. As you can see from the columns highlighted in green, I am actually selecting all those cells, but somehow it does not work.I overcame the problem once by listing the categories and the prices in the same columns, but in different rows and it worked. But I cannot believe that it’s not possible if the datas are on the same row, there must be a way, right?!I want to mention that I have a Mac and use Excel online, in case this influences it. I look forward to hearing from some expert ;)Thank you in advance  Read More

​