floating bars

[Blake 7]

Hi guys ---

pls see the data tab of the attachement.

Around BC62 if it doesnt open in the right place.

I am trying to create a floating bar effect for the diff bet act and bud.

I need to select the cols to change to secondary axis but the values is na! so a bit stuck

Also, Jwalks addin for including the value of the floater does not work with 2007 so this is also an issue...

any assistence out there!!!!

Thanks alot

[Andy Pope]

currently the chart has a single series so you can not move anything to the secondary axis.

If you switch data you will have multiple series and can therefore select and move.

You can use the drop down selector on the Format tab to select any data series that may not be displayed. Or use the Up arrow to cycle through chart elements.

As to the addin I assume this is some data label linkage. If so you will need a valid value before you can link the data label.

[Blake 7]

currently the chart has a single series so you can not move anything to the secondary axis.

If you switch data you will have multiple series and can therefore select and move.

You can use the drop down selector on the Format tab to select any data series that may not be displayed. Or use the Up arrow to cycle through chart elements.

As to the addin I assume this is some data label linkage. If so you will need a valid value before you can link the data label.

Hiya - am giving it a shot now. Cheers dude!