Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make this plot?
I am trying to make a column plot with two groups of data.
A a1 2 a2 2.5 B b1 3 b2 5.5 I am trying to make a1, a2, b1, b2 as stand alone column and I also want to have a series name for a1, a2 and another name for b1 and b2. Can I do this in Excel? If I try to make two series, it can only have 2 x axis values. Basically, I want to plot series A first and then series B. But I want to put them in the same plot.. Many Thanks. |
#2
|
|||
|
|||
No Summer?
This might do what you want. Arrange your data as shown below, and make your column chart. Series A will have two columns on the left, and series B will have two on the right. You can double click a series, and on the Options tab change the settings for Overlap and Gap Width to make it look better. A B a1 2 a2 2.5 b1 3 b2 5.5 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ springwinterfall wrote: I am trying to make a column plot with two groups of data. A a1 2 a2 2.5 B b1 3 b2 5.5 I am trying to make a1, a2, b1, b2 as stand alone column and I also want to have a series name for a1, a2 and another name for b1 and b2. Can I do this in Excel? If I try to make two series, it can only have 2 x axis values. Basically, I want to plot series A first and then series B. But I want to put them in the same plot.. Many Thanks. |
#3
|
|||
|
|||
Thank you so much. This is wonderful. You are truely an expert. I also
solved my first poblem based on your post. Many Thanks and Merry Christmas! Sincerely "Jon Peltier" wrote: No Summer? This might do what you want. Arrange your data as shown below, and make your column chart. Series A will have two columns on the left, and series B will have two on the right. You can double click a series, and on the Options tab change the settings for Overlap and Gap Width to make it look better. A B a1 2 a2 2.5 b1 3 b2 5.5 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ springwinterfall wrote: I am trying to make a column plot with two groups of data. A a1 2 a2 2.5 B b1 3 b2 5.5 I am trying to make a1, a2, b1, b2 as stand alone column and I also want to have a series name for a1, a2 and another name for b1 and b2. Can I do this in Excel? If I try to make two series, it can only have 2 x axis values. Basically, I want to plot series A first and then series B. But I want to put them in the same plot.. Many Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
Plot a line? Set dymanic axis Max min | Charts and Charting in Excel | |||
Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Barb Reinhardt: HOW TO: Plot a Team Name .... | Charts and Charting in Excel |