Display data by series in Excel chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to display data by series on a bar chart and am unable to do it.
I have seen charts displayed in this way. All ideas welcomed
 
I not sure I made myself clear. When I produce a standard bar chart with a
number of seires of data, the graphical representation shows the following:

Series 1 item 1, Series 2, item 1 series 3 item etc

I want to display the series in series order i.e series 1 item 1,2,3,4 etc
and then series 2 item 1,2,3,4

Hope this clarifies my query
 
That's more clear. I think all you need to do is change plotting by rows to plotting by columns
(or vice versa). On the Chart menu, choose Source Data, and on the Data Range tab, select the
option which is not selected.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 3
Odd Chart Format Results 1
Not plot a data series in a chart but still display in data table 1
Display Name of each Data Series 1
Convert Error Bars to Series and Colour 1
Embedded Chart Mouse Hover Difference - XL2007 vs XL2003 3
XY scatter plot with more than 32000 rows in Excel 2003 0
Data Table at Base of Chart 4

Back
Top