Тэги:
#chandoo #chandoo.org #Excel #spreadsheets #how_to_insert_target_line_in_excel_graph #how_to_add_a_target_line_in_an_excel_graph #how_to_add_target_line_in_excel_graph #how_to_add_a_target_line_in_excel_graph #how_to_put_target_line_in_excel_graph #how_to_add_average_line_to_excel_chart #how_to_add_average_line_in_excel #how_to_add_average_trendline_in_excelКомментарии:
Hello AWESOME Person... 👋👋👋
What other charting tips / ideas you want to see? Reply with your comments.
That helped, thankyou sir
ОтветитьNeed suggestions, strategies to increase sales that are below average line & also a seperate video on how to present data visualization in a meeting i.e, story telling...in detailed. Thank you
ОтветитьSuperb sir 👍
ОтветитьHi thank you for the all updates. I have multiple sheet with multiple info how can I change to one sheet
ОтветитьYou are awesome
ОтветитьWow. Great and easiest way... I'm day by day learn from your end lot of Excel short cut.... thanks master...keep posting your video
ОтветитьAfter your Beginner to Pro Excel Data Course, this playlist is next on my list. I've learnt so much from that one video. Here's to learning more from you.
Ответитьeasy tut. thanks from egypt
Ответитьhey , if i have 4 columns naming rev from product A,B,C,D respectively and 5th column which is parent id. now i want to find the average total rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products) .
what formula i should use?
Hi ,how to send emails from excel choosing email from.
In fact il have two accounts in outlook , personal one and groupe one and I want to choose the group one to send emails,.
Thank you for your feedback.
Same approach for a Goal (Percent of Improvement) line.
ОтветитьNice tip
ОтветитьSIR, why your channel is UNDERRATED.
ОтветитьI'm not able to convert column into line with microsoft excel 2010.
ОтветитьHi Chandoo. I subscribed to your channel today. Can you please make a video on "How to get clients for freelancing with excel" ?
ОтветитьSir, How to use "EDATE" {EDATE(start_date, -1)} functionality in "Power Query in Excel"
Means to calculate the previous date where, month is previous month but date is same
e.g.
I/p is 2 dec 2012 ==> O/p is 2 Oct 2012
I/p is 9 Jan 2011 ==> O/p is 9 Dec 2010
I/p is 4 apr 2013 ==> O/p is 4 May 2013
Been reading your tips and tricks through your blogs way back before. Good transition to YT though. Will keep on watching different tips every day. After all, Excel is the foundation and our best friend ;) Thanks for sharing chandoo.
ОтветитьWow... Nice One... 😀 Converting column to line never thought ....This one best. Thank you👍
ОтветитьGreat one Chandoo! Thanks for sharing how to add an average line with data label to an existing column chart. Very useful! Thumbs up!!
ОтветитьSimple and clear. Thanks very much
ОтветитьYou are always awesome👍👍
ОтветитьThank you!!
ОтветитьSimple and straightforward. Thanks for sharing Chandoo. 👍
ОтветитьIs there any platform on which we can ask questions? Please share
ОтветитьBest excel guru
ОтветитьThanks Chandoo!
Ответитьsir how to normalised data ?
Data like :
345
567
987
4566
99
5436
777
How to this data normalised in range between -100 to 100 ??? Please help
🙏🙏🙏
Thank you for the useful information
ОтветитьThis is great tricks, thank you
ОтветитьHello Chandoo,
Is there a calculation method that calculates the areas of the data under the line in excel?
Useful tip for setting target line(s) as well. 😃 Thanks for sharing this, I almost forgot the copy+paste trick. 😅
ОтветитьThank you ❤️
Ответить