Chart question

[bill_s1416]

Calling all smart people (geniuses) on this board:

I need to create a custom chart that does the following:

* Horizontal (left-to-right)
* Single data point moves along value axis (x-axis)
* Here's the cool part: the single data point must be a picture

Okay, I got "pretty" close, here's how:
- I created a bar chart (horizontal by default)
- I right-clicked the bar
- I selected "Format Data Series" then clicked the "Patterns" tab
- I then clicked the "Fill Effects" button then the "Picture" tab
- Then I clicked the "Select Picture" button
- Voila, the chart bar now contains my picture (bulldozer)

Here's the glitch:
I want the bulldozer to "move" to the right as the value increases.
Instead, there are only two ways I can set it. One, is on "stretch
which merely stretches the bulldozer picture very long an
weird-looking as the value increases. The only other setting i
"stacked" which merely shows multiple bulldozers in the bar, increasin
in number as the value increases and the bar gets longer.

I need the bulldozer picture to NOT "stretch" nor "multiply" but rathe
to stay at the right end of the bar and just move to the right as th
value increases.

Can anyone help?

Thanks much! :confused

 

[Debra Dalgleish]

You could use two values to create a stacked bar chart. For example:

Enter your value in cell B2
In cell B3, enter: =B2-B4
In cell B4, type a value that will create enough space for your picture.
You can experiment with this after you create the chart

Select cells B3:B4, and create a stacked bar chart
Right-click on Series 1 in the chart
Choose Format>Selected Data Series
Set the Border and Area to None, click OK
Right-click on Series 2 in the chart
Choose Format>Selected Data Series
Click the Fill Effects button, select your picture, click OK

Adjust the number in cell B4, if necessary, to provide room for the picture

You may also need to double-click on the Value axis, and set its minimum
value to zero.

 

[bill_s1416]

Debra, thank you. It works nice