| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change overlap of 2 columns on 2 axes
I am trying to plot 2 columns of data on the same X-axis but on 2 Y-axis
plots. But the columns are overlapping and I can't see one set of data. I don't want them stacked and changing the gap and overlap width doesn't seem to do anything. Suggestions? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change overlap of 2 columns on 2 axes
Hi,
You need to add 2 dummy series to act as place holders. Example data set in range A1:E4 B1: =Left C1: =DumRight D1: =DumLeft E1:=Right A2: =One B2: =1 C2: =0 D2: =0 E2: =3 A3: =Two B3: =2 C3: =0 D3: =0 E3: =2 A4: =Four B4: =3 C4: =0 D4: =0 E4: =1 Start by creating a column chart on the range A1:E4 Set the 3rd and 4th series to the secondary axis. Remove extra items from legend if required. Cheers Andy Charles wrote: I am trying to plot 2 columns of data on the same X-axis but on 2 Y-axis plots. But the columns are overlapping and I can't see one set of data. I don't want them stacked and changing the gap and overlap width doesn't seem to do anything. Suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change overlap of 2 columns on 2 axes
Is there a way to just change the graph without having to start over. My
dataset is pretty complicated. "Andy Pope" wrote: Hi, You need to add 2 dummy series to act as place holders. Example data set in range A1:E4 B1: =Left C1: =DumRight D1: =DumLeft E1:=Right A2: =One B2: =1 C2: =0 D2: =0 E2: =3 A3: =Two B3: =2 C3: =0 D3: =0 E3: =2 A4: =Four B4: =3 C4: =0 D4: =0 E4: =1 Start by creating a column chart on the range A1:E4 Set the 3rd and 4th series to the secondary axis. Remove extra items from legend if required. Cheers Andy Charles wrote: I am trying to plot 2 columns of data on the same X-axis but on 2 Y-axis plots. But the columns are overlapping and I can't see one set of data. I don't want them stacked and changing the gap and overlap width doesn't seem to do anything. Suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change overlap of 2 columns on 2 axes
You could try this,
Go to the Source Data dialog and Add 2 new series. The will have a value series of ={1} , which you can change to ={0} after formatting. Select one of the newly added data series and move to secondary axis. Repeat for the valid data series you want on the right of each cluster. If the columns are not how you want use the Series Order option on one of the data series on the secondary axis to switch left/right position. Cheers Andy Charles wrote: Is there a way to just change the graph without having to start over. My dataset is pretty complicated. "Andy Pope" wrote: Hi, You need to add 2 dummy series to act as place holders. Example data set in range A1:E4 B1: =Left C1: =DumRight D1: =DumLeft E1:=Right A2: =One B2: =1 C2: =0 D2: =0 E2: =3 A3: =Two B3: =2 C3: =0 D3: =0 E3: =2 A4: =Four B4: =3 C4: =0 D4: =0 E4: =1 Start by creating a column chart on the range A1:E4 Set the 3rd and 4th series to the secondary axis. Remove extra items from legend if required. Cheers Andy Charles wrote: I am trying to plot 2 columns of data on the same X-axis but on 2 Y-axis plots. But the columns are overlapping and I can't see one set of data. I don't want them stacked and changing the gap and overlap width doesn't seem to do anything. Suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change overlap of 2 columns on 2 axes
That did it, Thanks!
"Andy Pope" wrote: You could try this, Go to the Source Data dialog and Add 2 new series. The will have a value series of ={1} , which you can change to ={0} after formatting. Select one of the newly added data series and move to secondary axis. Repeat for the valid data series you want on the right of each cluster. If the columns are not how you want use the Series Order option on one of the data series on the secondary axis to switch left/right position. Cheers Andy Charles wrote: Is there a way to just change the graph without having to start over. My dataset is pretty complicated. "Andy Pope" wrote: Hi, You need to add 2 dummy series to act as place holders. Example data set in range A1:E4 B1: =Left C1: =DumRight D1: =DumLeft E1:=Right A2: =One B2: =1 C2: =0 D2: =0 E2: =3 A3: =Two B3: =2 C3: =0 D3: =0 E3: =2 A4: =Four B4: =3 C4: =0 D4: =0 E4: =1 Start by creating a column chart on the range A1:E4 Set the 3rd and 4th series to the secondary axis. Remove extra items from legend if required. Cheers Andy Charles wrote: I am trying to plot 2 columns of data on the same X-axis but on 2 Y-axis plots. But the columns are overlapping and I can't see one set of data. I don't want them stacked and changing the gap and overlap width doesn't seem to do anything. Suggestions? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
| How can I change the number of columns in the middle of the page? | Excel Discussion (Misc queries) | |||
| How do I change columns going from left to right to rows going up. | Excel Discussion (Misc queries) | |||
| Change Axes Scale Dynamically | Charts and Charting in Excel | |||
| Change number of columns mid page? | Excel Worksheet Functions | |||
Hybrid Mode
