Write steps to construct the following charts to display year along X Axis and sales of the two depots along Y Axis: (a) A 3-D column chart (b) A Line chart with column series (Excel-2007)
Write steps to construct the following charts to display year along X Axis and sales of the two depots along Y Axis:
(a) A 3-D column chart
(b) A Line chart with column series
First select Range of cells B1:B6
and KEEP THE CONTROL KEY PRESSED and now select range of cells E1:E6.
Click on insert tab ,Here click on BAR in charts group. From sub-chart options select 3-D bar chart.
Now the Chart is prepared , Now to add Year to horizontal axis , select DATA source dialog box, now select the range of cells A2:A6 and click on Ok.
0 comments:
Post a Comment