Today I had a need to do a graph in Excel where it need to display a stacked column chart and also a line in the same graph.
The data for this is as follows for three years
2008 2009 2010
12000 14000 16000
1000 1000 1000
170000 180000 200000
I wanted a stacked column with the first two rows and a line with the last row. But when I chose the normal 2d column chart, it was showing all three rows as one stacked column.
To get the desired results, I followed the following steps
First, include all three rows in the series part of the chart data and choose the 2d stacked column chart
Next, right-click on the colored part of the bar that corresponds to the year and choose "Chart Type". Then select the first Line graph. Click Ok
Finally, right click on the graph and choose chart options and tick the 'Value Y Axis' tick box under the secondary axis lable of the 'Axes' tab
You should now have the first two rows displayed as a stacked column chart and the third row displayed as a line graph above your columns.
At my work I have inherited a database where the partitioning was not done correctly. This database holds millions and millions of records...
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...