Thanks, all. Both solutions work!
Riny, thanks for the reply. I would want the 10 smallest numbers including any duplicates (your 1st example). I am using Excel 2016, so I suspect th...
Hi Mynda, thanks for the clarification. I added the number format to the chart labels. My only problem now (refer to the earlier attachment "Call-Vo...
Mynda, I agree with you, and your reference to the Custom Number Format and Custom Chart Labels articles gave me what I needed. A pivot table is unne...
Mynda, thanks. Attached is a sample Excel file with data and a pivot table. I will be very interested to see how this may be done! I should mention...
Another follow-up: When I have the columns highlighted, and combine it with a line graph, it works great. But if I want to have one of the lines to ...
A quick follow-up question: Regarding the shaded periods, is there a way to have the shading go below the x-axis so that it includes the time period l...
Thank you Mynda, that worked perfectly!
Thank you. I will apply your solution and advise. It is true that my data table is entirely first initial last, with a few suffixes (Jr., III, etc.)...