| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
