Hi all,
I have two sheets. Sheet 1 (“Overview”) contains raw data, Sheet 2 (“Charts”) contain XY plots.
On sheet 1, I have a table with four columns. 1) Company, 2) Industry, 3) Metric one, 4) Metric two. Based on filters applied to the industry-column, I’d like the XY plot to automatically update to only include data from the filtered table. This has been fairly straight forward, and does not seem to have any issues. However, instead of having boring dots as markers with the respective company names as data labels, I’d like the companies’ logo to be displayed instead. Ideally, I would add another column to the table and insert logos of the respective companies from which the data markers can be sourced from.
I have already tried to paste logos into the respective data markers, however, when changing the filter, excel seems to randomly assign the logos.
As of right now, I have not used any VBA – but it seems inevitable at this point. Unfortunately, I have very limited experience with VBA, so I hope there is a wizard out there to help me out.
Thank you so much.
I have two sheets. Sheet 1 (“Overview”) contains raw data, Sheet 2 (“Charts”) contain XY plots.
On sheet 1, I have a table with four columns. 1) Company, 2) Industry, 3) Metric one, 4) Metric two. Based on filters applied to the industry-column, I’d like the XY plot to automatically update to only include data from the filtered table. This has been fairly straight forward, and does not seem to have any issues. However, instead of having boring dots as markers with the respective company names as data labels, I’d like the companies’ logo to be displayed instead. Ideally, I would add another column to the table and insert logos of the respective companies from which the data markers can be sourced from.
I have already tried to paste logos into the respective data markers, however, when changing the filter, excel seems to randomly assign the logos.
As of right now, I have not used any VBA – but it seems inevitable at this point. Unfortunately, I have very limited experience with VBA, so I hope there is a wizard out there to help me out.
Thank you so much.
