View Single Post
  #1   Report Post  
BHARATH RAJAMANI
 
Posts: n/a
Default User-defined (Custom) Charts

Problem: Super-impose line chart over stacked column, both data sets are
different
Data Set 1:
A2:A28 -- Market Segments
B1:I1 -- Months (Dec 2004 -to- July 2005)
B2:I28 -- Market share (%) values, each column (B:I) sums to 100%
Stacked column (market share) .. easy and done

Data Set 2:
Herfindahl Index - Values in B29:I29
Line plot over Months .. easy and done

I need to superimpose the line plot over the stacked column, how do i do
that one?


TIA!


--