#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
column clustered bar graph with a line graph as secondary axis | Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Push data automatically from Acess or Excel to create a Gantt chart in Project | GST2212 | Project | 3 | 07-06-2012 12:52 PM |
Create PPT slide presentation with Excel data. Chart is displayed off the slide. | eratem | PowerPoint | 4 | 02-29-2012 09:44 AM |
How to create an Excel add in that will automatically build tables from data | selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |
how do I add data values in Col A into X axis on bar graph? | hazz | Excel | 1 | 04-27-2010 01:42 PM |