View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Have drawing object automatically move around point on graphaxis

Select it and then via the menu Chart Chart Type.

You can use the cursor keys to cycle through the chart elements if the
data series is not easy to click with the mouse.

Jeff wrote:
How do I change just those series to a stack bar/column chart?


"Andy Pope" wrote in message
...

Hi,

Add 2 data series. Change both new series to stack bar chart.
The first of these new series should have a value equal to the lowest
value. The 2nd should have a value equal to the width of the shaded area.
In order to complete the chart you will need to,
Format the 1st series to have no fill or border.
Format the 2nd series to have no border, Yellow fill, Series Options Gap
Width of zero.
Format secondary x axis to have the same min and max scale values as the
primary x axis.

Cheers
Andy





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info