LinkBack URL
About LinkBacks
I can't figure out how to create a stacked column chart in Excel 2007. For example: I have a set of data: data1 1,000; data2 2,000; data3 3,000; total 6,000. How can I create a simple stacked column from these data?
I can't figure out how to create a stacked column chart in Excel 2007. For example: I have a set of data: data1 1,000; data2 2,000; data3 3,000; total 6,000. How can I create a simple stacked column from these data?
Assuming your data is in A1:B3 then select the range and insert a stacked column chart.
Because of the data layout Excel plots the Data1,Data2,Data3 as category labels and thinks you only have 1 series. So your chart looks like a normal cluster column chart.
You need to swap the rows/columns so it plots Data1,Data2 and Data3 as series with a single category label.
Chart Tools > Design > Data > Switch Row/Column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks