View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Combination charts

Sorry but that data example doesn't really help as I can not figure out
what you are trying to plot.

Are the years plotted as series? In which case you need more % values.
If the stacks are for each year then you need to move the % values to
the secondary axis and change the chart type to line.

Cheers
Andy

osof wrote:
Here are sample values

0.00%
2005 ($28,000) $28,000 $47,000 $9,000
2006 (30,000) 42,000 50,000 11,000 330.80%

I put the zero before 2005 because the line series are the percentage ones
and it starts at 0.
Thanks for all the help.I appreciate it...