Dynamic Markers on Scatter Charts
- Thread starter gregs
- Start date
Hui,
Thanks for responding. I had already looked at that post, which is really clever and I'm sure I will use it someday. But I don't see how that post can help with the problem I'm currently having.
I need to make some visual markers on a series of charts that tell the audience one of 4 characteristics of each data point in addition to its location on the 2 dimensional chart. What I am plotting is the business value and intellectual property (IP) value of a set of patents on the graph. The additional data that I want to show by the type of marker for each point is whether the IP is a competitor strength, my company's strength, or both, and if there is an opportunity to create additional IP in the category. That data is contained in additional columns on the spreadsheet.
Greg
Thanks for responding. I had already looked at that post, which is really clever and I'm sure I will use it someday. But I don't see how that post can help with the problem I'm currently having.
I need to make some visual markers on a series of charts that tell the audience one of 4 characteristics of each data point in addition to its location on the 2 dimensional chart. What I am plotting is the business value and intellectual property (IP) value of a set of patents on the graph. The additional data that I want to show by the type of marker for each point is whether the IP is a competitor strength, my company's strength, or both, and if there is an opportunity to create additional IP in the category. That data is contained in additional columns on the spreadsheet.
Greg
So you will add 4 series
Most of the data for the series will be =NA()
except for the coordinates where you want your markers
Set the markers for each series as you want with/without a legend annotated
Set the string line as no color
the 4 series can be linked to your existing data
If you want to send me an email click on the "Excel Ninja" words under my Avatar and the email address is at the bottom of the page
put enough detail in the file to let me know what your trying to achieve
Most of the data for the series will be =NA()
except for the coordinates where you want your markers
Set the markers for each series as you want with/without a legend annotated
Set the string line as no color
the 4 series can be linked to your existing data
If you want to send me an email click on the "Excel Ninja" words under my Avatar and the email address is at the bottom of the page
put enough detail in the file to let me know what your trying to achieve