![]() ![]() ![]() ![]() To use it, you will need to enter the values for the chart in 5 columns, anywhere in the worksheet. The macro is pretty rough, but was sufficient for my needs as is, so I haven’t put extra efforts in: feel free to improve upon it… I quickly coded a VBA macro to do that, with a sample workbook to illustrate the usage. You could think of this as plotting 5 dimensions at once, instead of the usual two. Recently, a client asked me if it was possible to create an Excel scatter plot of his products, adding a label on each data point, and using different colors and symbols for different types of products. Excel ScatterPlot with labels, colors and markers ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |