Sure, the seriesname shows in the Legend, but I want the name to display on the column or the line as if it was the value or xaxis label The only way I know is to create text boxes or other objects and handtype each name, etc Thank you Now excel shows highlighted border around the cells from which the chart series is created Just click on the bottomright corner and drag it up and down to edit the chart series data ranges (more Edit formula ranges using mouse) See the demo to understand this More tricks to make dynamic charts using Excel Here is a list of tutorials and examples recommend just for Creating a multicategory chart in Excel To create a multicategory chart in Excel, take the following steps 1 Arrange the data in the following way Enter main category names in the first column, subcategory names in the second column and the figure for each subcategory in the third column in the format shown below
How Can I Plot Multiple Columns As A Single Continuous Series In Excel Super User
