+ Reply to Thread
Results 1 to 6 of 6

how to add a picture for each series in a chart

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    ath
    MS-Off Ver
    Excel 2019
    Posts
    53

    how to add a picture for each series in a chart

    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

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: how to add a picture for each series in a chart

    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
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    ath
    MS-Off Ver
    Excel 2019
    Posts
    53

    Re: how to add a picture for each series in a chart

    hi there
    thanks for the reply
    attached i have a file of what i want to do

    thaks again
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: how to add a picture for each series in a chart

    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
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    ath
    MS-Off Ver
    Excel 2019
    Posts
    53

    Re: how to add a picture for each series in a chart

    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

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: how to add a picture for each series in a chart

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-19-2017, 07:52 PM
  2. Delete Pivto Chart Series when certain word/text is found in the Series Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2016, 03:19 PM
  3. Apply format of a series to a similar series in a different chart
    By Skiffie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2013, 10:43 PM
  4. Chart front-to-back series display if series are different chart types
    By Exconomist in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2012, 06:49 AM
  5. Series function disappears from Chart series edit
    By lloydsp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 07:45 PM
  6. mixing column chart types for series and macro series?
    By riwiseuse in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-30-2010, 05:27 PM
  7. [SOLVED] chart data series -- plot a table as a single series
    By hjc in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-20-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1