View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
LDP Analyst[_2_] LDP Analyst[_2_] is offline
external usenet poster
 
Posts: 10
Default Change category axes from drop down selection

Can I change the category axes for a chart linked off of what is chosen in
the drop down? I have a list of region-area-individual stores, and I want to
chart the individual stores when I chose an area. all of the area's when I
choose a region, etc. Is there a way to autopopulate the chart axes to do
that simply by selecting a drop down reference?