Chart with Running Man

[323100N]

Is it possible to create a regular chart or using macro that will show a running man logo on each end of the graph?
and with a Miles Marker on top of the Chart


Miles and Label
3.1 = 5K
6.2 = 10K
13.1 = Half MArathon
26.2= MArathon
39.3 = Marathon and a Half
52.4 = 2 Marathons
70.3 = Half Iron Man
100.0 = 100 Mile Race
140.6 = Ironman Trianthalon

Thank you


Please see attached file.

[Andy Pope]

You can use a custom fill on a stacked bar chart

[323100N]

I cant apply to my chart

[Andy Pope]

Why not, what does your chart look like?

[323100N]

actually may chart looks like in one sheet 2 and the source is on sheet 1, I'm trying to apply your provided sample but It ruins the format of my graph

[323100N]

Can you apply the running man to sheet 2?

[kersplash]

I've added one for you, you probably need to find a better picture for the size of your chart as the bars are tightly packed.

[323100N]

Yeah! that's is why I'm trying to change the format of the chart or style. Thank you! I really appreciated your help

[Andy Pope]

As kersplash has done, you just need to add another series to the chart and use a picture fill.

[323100N]

Thank you guys! much appreaciated

[323100N]

Is it possible to label my Upper Chart portion into this
3.1, 6.2, 13.1, 26.2, 39.3, 52.4, 70.3, 100.0, 140.6

Instead of 0,10,20,30,40,50,60?

Thank you

[Andy Pope]

Yes, but as the spacing is not equi spaced you will need to build the labelling yourself with an extra data series.

Add a new series
Change series to xy-scatter
use select data dialog to select data for x and y values.

Format secondary vertical axis to have a max of 1.
Add data labels to new series and display X value above data point.
Format data point as required
If you want gridlines then add error bars. Delete horizontal error bar and format vertical to have fixed minus value of -1

I have left the secondary vertical axis in place so you can see how it was done, but this can be deleted

[323100N]

Thank you! a great help with me, your help are much appreciated.

[323100N]

how to maximize the charts width so that the last axis 140.6 will be visible? thank you

[Andy Pope]

set the horizontal axis to be Auto rather than fixed at 60.