hi there
does anybody know how can i add a picture or a logo for each diferent series in a excel chart
thank you in advance
hi there
does anybody know how can i add a picture or a logo for each diferent series in a excel chart
thank you in advance
We need more information about the type of chart, where the picture should appear in relation to the chart and the series.
You can use pictures to fill a column or bar chart.
You can use pictures as data markers
hi there
thanks for the reply
attached i have a file of what i want to do
thaks again
you can use a second series on the secondary axis. You can set the fill picture of each point in the logo series.
In the example I used the shapes you had as an example.
You need to set both horizontal axes to have the same minimum and maximum values.
A custom number format will remove the negative values from horizontal axis.
Only thing you can not remove is the left most grid line
hi there
thanks for the relpy
what i actualy looking for is this graph to be dynamic
the images not just to placed there but to be able the graph to pick the images
let us say in case that in another graph i dont have all the cpm but just 2 of them to have the images of these 2 only
i dont know if that is clear
That would only be dynamic if you ran VBA code to update the fill picture.
If you want a dynamic solution then just use VBA to size and position images. Not sure what you would use in terms of an event in order to update existing images.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks