 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2007Change 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? 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 > 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?  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Is there a way to just change the graph without having to start over. My dataset is pretty complicated. > Hi, > [quoted text clipped - 19 lines] > > > > Suggestions? 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 > Is there a way to just change the graph without having to start over. My > dataset is pretty complicated. [quoted text clipped - 22 lines] >>> >>>Suggestions? SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info That did it, Thanks! > You could try this, > [quoted text clipped - 35 lines] > >>> > >>>Suggestions? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.