scatter graph and marker labels with multiple series

[tkotko123]

Please Login or Register  to view this content.

I am tryimng to graph some data within a scatter graph. I get the data to graph with no problem. The problem is that I want to label each data with a specific title. I used the below macro (thank you to whomever posted it) and was able to get the desired result when I used only one series. When i added a second i could not get the labeling. I have attached a sample of what I am trying to achieve.

any help would be greatly appreciated.

Please Login or Register  to view this content.

thank you.

[pimpmychart]

I don't know how to do that with a macro, but given the relatively small number of data points (14), why don't you label manually? I quickly added labels to both data series and linked them to the names in column O. It took me two minutes. Is that what you want?

[tkotko123]

The sample was just for a visual. I have up to 5 series and up to 45 data points for each so the manual process would be too....manual

[pimpmychart]

Do you know the chart labeler?
It's an excel add in available at: http://appspro.com/Utilities/ChartLabeler.htm

Very easy to use!

[teylyn]

tkotko123, welcome to the forum. However,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[tkotko123]

Unfortunatley I am working on my work computer and the security settings will not allow.