Ehcacommence
12-09-2017, 12:18 PM
Hi all !
Firstly, I should probably mention that I "cross posted" this thread. (i.e. https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1196780-chart-excel-2013-serie-highlight-on-label-or-chart-column-mouse-over)
I beleive that what I want Excel to achieve would require a macro, I might be wrong though, but I found no other mean to get what I want.
I am sorry, I will not be able to provide anyone willing to help with a sample code because I am, at most, an unskilled beginner having no idea of how to write such a macro. I did look for it on the Internet but didn't find anything relevant.
Right, given that, let me get started.
21135
Here is attached a showcase excel file. I'm working on Excel 2013.
The column A contains several Identities (long identities, no very reader friendly when used for a chart, but I need them to remain what they are for the chart to be relevant).
The column B contains data corresponding to column A identities.
I create a chart to expose column B data as a function of column A identities, column A identities are then series.
I have labels over the columns of the chart, and series shown at the bottom of the chart.
Because I could have to use huge numbers of different identities, I would like the chart columns to let the user know what is the serie that column is related to. Excel does that on its own with a simple mouse over on the chart columns, with a pop-up window that is not very reader friendly:
"Series "Identity that is way too long 1" Point "Data" Value: 1196"
Because these identities are so long and I can't possibly make them any shorter, I can't have every single Identity standing on the top of the chart column it belongs to.
So what I would like to achieve is :
On a chart column (or on a label, if it is easier than a chart column) mouse over, the serie it is related to is highlighted in the Legend entry.
That is it ! (On the sample file I did not put labels for every single column but that would usually be the case).
If anyone is willing to share with me how to achieve this, that would really help me out ! :p
Thanks a lot for reading, and an even bigger thank to anyone trying to help !
Cheers,
Ehcacommence.
Firstly, I should probably mention that I "cross posted" this thread. (i.e. https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1196780-chart-excel-2013-serie-highlight-on-label-or-chart-column-mouse-over)
I beleive that what I want Excel to achieve would require a macro, I might be wrong though, but I found no other mean to get what I want.
I am sorry, I will not be able to provide anyone willing to help with a sample code because I am, at most, an unskilled beginner having no idea of how to write such a macro. I did look for it on the Internet but didn't find anything relevant.
Right, given that, let me get started.
21135
Here is attached a showcase excel file. I'm working on Excel 2013.
The column A contains several Identities (long identities, no very reader friendly when used for a chart, but I need them to remain what they are for the chart to be relevant).
The column B contains data corresponding to column A identities.
I create a chart to expose column B data as a function of column A identities, column A identities are then series.
I have labels over the columns of the chart, and series shown at the bottom of the chart.
Because I could have to use huge numbers of different identities, I would like the chart columns to let the user know what is the serie that column is related to. Excel does that on its own with a simple mouse over on the chart columns, with a pop-up window that is not very reader friendly:
"Series "Identity that is way too long 1" Point "Data" Value: 1196"
Because these identities are so long and I can't possibly make them any shorter, I can't have every single Identity standing on the top of the chart column it belongs to.
So what I would like to achieve is :
On a chart column (or on a label, if it is easier than a chart column) mouse over, the serie it is related to is highlighted in the Legend entry.
That is it ! (On the sample file I did not put labels for every single column but that would usually be the case).
If anyone is willing to share with me how to achieve this, that would really help me out ! :p
Thanks a lot for reading, and an even bigger thank to anyone trying to help !
Cheers,
Ehcacommence.