Picture instead of a line

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I would like to create a column chart and use a picture
for the Bar lines (Like Coins) how can this be done?

The chart is demonstrating how the investment is growing,
so a pile of dollar bills or coins will be better then
just a line.
Please help

Thanks
Joe
 
I would like to create a column chart and use a picture
for the Bar lines (Like Coins) how can this be done?

The chart is demonstrating how the investment is growing,
so a pile of dollar bills or coins will be better then
just a line.
Please help

Thanks
Joe
Click to expand...

Joe,
The following does work in Excel, but the Insert Menu is not enabled
in Chart Edit mode in Access 2002.
Perhaps this will give you some ideas though.

In Excel, after you have created your bar chart....
select the data series you want to format.
Then, choose Insert + Picture + From File from the menu bar.
Locate and select the picture you want to use.
Click Insert and Excel will apply and resize the picture to each
data point.

I know you can copy the chart and paste it into an Access Report, but
the data is not updateable this way.
Perhaps you can make the chart in Excel and import it into Access and
have it update as needed. I haven't tried that.
 
Back
Top