Use pictures in bar charts depending on the fields shown

[NickiP]

Hi,

I've created a bar chart where the number of items on the x-axis changes depending on previous user input. I would like the bar that is displayed for each of these to have a different graphic that is automated based on the x value. For example, A, B, C, D or E are all events, however only A, C, and D are relevant to this particular assessment. I therefore want picture A to be filled in to the corresponding A bar, picture C to be filled in to the corresponding C bar, and picture D filled in to bar D. Likewise, the next assessment may only involve B and C, and so I want the graph to select these fills for the chart.

Any help would be greatly appreciated.

Thanks,

Nicki

[Ron Coderre]

Welcome to the forum.
Since this is a moderated forum, please take a moment to read the forum rules (at the Forum Rules link, above)

One of the rules pertains to cross-posting the same issue to more than one forum. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Because you're new, I'll post the link for you....this time.
http://www.mrexcel.com/forum/excel-q...lds-shown.html