How to create a column graph from row data in excel
Hi,
I want to create a column graph with row data in excel. When I try to graph rows the graph shows a bar graph for each column that the row data is in. Basically the graph shows a column for each row of data, and I want it to show the WHOLE row as 1 column, as if the data was organized in columns, not rows.
I have attached an excel file with a row for SEO and PPC. I want the entire row of SEO to appear as a column in the column graph. I want do a stack graphed for SEO and PPC, where it shows the proportion of each of the total. I have put in the graph that I am getting when I try to graph the row, which has a column bar on the graph for each row (this is not what I want). I want the data to show as if it was a column of data. Can someone please give me the steps to convert the rows to a column graph? Thanks.
p.s. I checked online and it said to switch/row column but that does nothing to correct the problem.
|