@thestarmoon7 , yes, but you would have to make a formula to convert the numbers to percents and then plot the percentages. The relationship between the column heights will be the same.
how do you make a column in between 2 other columns? D:
Insert a new row between rows 5 and 6. Enter Dallas in cell A6, 105985.12 in cell B6, 98674.38 in cell C6, 100548.22 in D6, and 106222.17 in E6. Copy the function in cell F5 down to cell F6 to sum the values in the new row.
I am trying to prep for a job interview and charting would be huge responsibility of the job. Your tutorial is very thorough. Thank you for putting this online.
Thank you so much for your tutorials! I teach Excel classes at my job and refer staff to your videos / resources for continual learning...I watch your vids for fun / refresh! Excel-lent delivery btw! (Was awesome to see you and Bill-Mr. Excel- collab also)
How can you change the color of the lines in the line graph?
MistahLaiLai 1 week ago
@MistahLaiLai , right-click the line, Format, Line Color
ExcelIsFun 1 week ago
can i ask one thing using the column bar chart it is possible to have the result in percentages?
thestarmoon7 1 week ago
@thestarmoon7 , yes, but you would have to make a formula to convert the numbers to percents and then plot the percentages. The relationship between the column heights will be the same.
ExcelIsFun 1 week ago
@ExcelIsFun thankz
thestarmoon7 1 week ago
Thank you do much! I was doing a project for my college class and could not figure out what to do for the pie charts!
STruitt1020 3 months ago
how do you make a column in between 2 other columns? D:
Insert a new row between rows 5 and 6. Enter Dallas in cell A6, 105985.12 in cell B6, 98674.38 in cell C6, 100548.22 in D6, and 106222.17 in E6. Copy the function in cell F5 down to cell F6 to sum the values in the new row.
please help.
RageChanTheYaoiFan 8 months ago
Right-click EXCEL ROW HEADER 5, point to Insert.
ExcelIsFun 8 months ago
I am trying to prep for a job interview and charting would be huge responsibility of the job. Your tutorial is very thorough. Thank you for putting this online.
BellaLucia2009 9 months ago
I am glad that the video helped!
ExcelIsFun 9 months ago
Thank you so much for your tutorials! I teach Excel classes at my job and refer staff to your videos / resources for continual learning...I watch your vids for fun / refresh! Excel-lent delivery btw! (Was awesome to see you and Bill-Mr. Excel- collab also)
rabbiltube 11 months ago
I am glad that the videos are of use to you!
ExcelIsFun 11 months ago
nice tutorial, way too long tho
nathaniel6677 1 year ago
REALLY AWESUM tutorial though, I love it!
SuperSloeberCookie 1 year ago
I am glad that you like it!
ExcelIsFun 1 year ago
I have a question: I was making a axis title at my x-y scatter, and I made a title, but it didn't automatically resize the chart.
how do I do that?
'cause my titles are now right THROUGH my chart.
SuperSloeberCookie 1 year ago
Try: Chat Tools Layout ribbon, Labels group, Chart Title, "Above Chart" (instead of "Center Overlay Title").
ExcelIsFun 1 year ago
keep the good job man
thanks
seriously, thanks
swimlforever 1 year ago
You are welcome!
ExcelIsFun 1 year ago