Further reduce clutter by unchecking Multi Level Category Labels option So you can just have Product Group & Product Name in 2 columns and when you make a chart, excel groups the labels in axis.Ģ. This technique really works with just any types of data. Play with the formulas & chart formatting to learn. Pretty simple, eh? Download the Excel Chart TemplateĬlick here to download excel chart template & workbook showing this technique. Excel shows nicely grouped axis labels on your chart. Use both year and month columns for axis label series.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |