View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
W Wheeler W Wheeler is offline
external usenet poster
 
Posts: 1
Default Multiple Chart Ranges

I have a ten year monthly bar chart that shows all of January together,
February together, etc. I would like to add a secondary axis marker on these
bars with data from another data range. Does anyone know how this can be
done? Creating the chart from a pivot table does not work well because it
does not color code by year.