Airtel,
You can assign individual data series to the secondary axis.
Right click on the data series, select format data series, and on the
axis tab select secondary axis.
With some graphs you will want to use both different rows AND
different columns for the data that you want on the secondary axis.
This may cause double entries in your legend, so just format similar
data series the same color, etc, and delete out unwanted legend
entries.
Good luck
On Tue, 8 Mar 2005 01:53:01 -0800, Airtel
wrote:
I had prepared a chart for Sales Presentation, i have data for six different
marketing segments and their total, from april to Feb'05, can i display both
sales figure as well as their contribution to their respective totals (in
%age). it should depect the sales figure and their respective %age achieved
in the same bar graph.
|