hi, how can i download all your sheets for practice? also can you let me know how you wrapped horizontal axis text? for me the months are overlapping. thanks
All I did was to drag the lrft or right edge of the chart and it wrapped it automatically. There is a way to do it with a formula. If your serial date was in cell B13, this formula would wrap the date:
=TEXT(B13,"mmm")&","&CHAR(10)&TEXT(B13,"yy")
Then you could copy it down the column to create all your dates. Then you could use those dates in the chart. This formula will not work with the dates in the video becasue the dates are text.
@ExcelIsFun Got it, many thanks! Getting hooked to your lessons! By the way can you tell me how not to to show error values (#NA) in a chart based on a fixed data range e.g I have a data range from E2 to I10 which picks up data based on formula. My chart should show only the non-error values (My five columns are Month, Executive Name,Product type,Quantity and Value). Pls advise.
YouTube is not a good place to have discussions about Excel solutions. The best site to ask Excel questions is:
mrexcel[dot]com/forum
Many people can then provide answers. Best thing about site is we can post examples and are not limited with length of replies. If you post, then send me the link, although many people will answer. Also be sure to explain your questions clearly. The more clear your questions, the more replies you will get.
hi, how can i download all your sheets for practice? also can you let me know how you wrapped horizontal axis text? for me the months are overlapping. thanks
meami111 1 year ago
Search YouTube for "excelisfun", click on the channel link, watch the video that auto plays, it tells all.
ExcelIsFun 1 year ago
@ExcelIsFun thanks got the link but can you answer the second part of my question?
meami111 1 year ago
All I did was to drag the lrft or right edge of the chart and it wrapped it automatically. There is a way to do it with a formula. If your serial date was in cell B13, this formula would wrap the date:
=TEXT(B13,"mmm")&","&CHAR(10)&TEXT(B13,"yy")
Then you could copy it down the column to create all your dates. Then you could use those dates in the chart. This formula will not work with the dates in the video becasue the dates are text.
Maybe I will make a video.
ExcelIsFun 1 year ago
Try this video:
Excel Magic Trick #228: Text Formula & Forced Wrap Text
ExcelIsFun 1 year ago
@ExcelIsFun Got it, many thanks! Getting hooked to your lessons! By the way can you tell me how not to to show error values (#NA) in a chart based on a fixed data range e.g I have a data range from E2 to I10 which picks up data based on formula. My chart should show only the non-error values (My five columns are Month, Executive Name,Product type,Quantity and Value). Pls advise.
meami111 1 year ago
YouTube is not a good place to have discussions about Excel solutions. The best site to ask Excel questions is:
mrexcel[dot]com/forum
Many people can then provide answers. Best thing about site is we can post examples and are not limited with length of replies. If you post, then send me the link, although many people will answer. Also be sure to explain your questions clearly. The more clear your questions, the more replies you will get.
ExcelIsFun 1 year ago
@ExcelIsFun @ExcelIsFun Dear Mike, pls have a look at my post:
mrexcel[dot]com/forum/showthread[dot]php?t=512653
meami111 1 year ago
Please send link to me by e-mail.
ExcelIsFun 1 year ago
@ExcelIsFun Pls send me your email ID. Could not find it in youtube.
meami111 1 year ago
Clcik on the blue excelisfun link, then at the excelisfun channel, click on the "Send Message" blue link.
ExcelIsFun 1 year ago
@ExcelIsFun Thanks. I have sent it. Do have a look
meami111 1 year ago
You make working with excel really fun! Thanks for the great work!!
meami111 1 year ago
You are welcome!
ExcelIsFun 1 year ago
Is there any way to show the data on the chart for the hidden rows?
aranpan2006 1 year ago
I do not know how to do it.
ExcelIsFun 1 year ago
subscribe!!. thanks for the goodies
truviet911 2 years ago
You are welcome!
Thanks for the 5 star ratings!!
ExcelIsFun 2 years ago