 |
 | 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 / New Users / April 2008stacked column chart
How do you do a stacked column chart with 2 stacks and 1 line above the columns plotting values. This line doesn't touch the columns. This chart has 2 axis. Thanks for any help on this. Hello Jay: Which version of Excel are you using? The answer is different for the different versions.  SignatureHope this helps Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand Please do not forget to rate this reply. > How do you do a stacked column chart with 2 stacks and 1 line above > the columns plotting values. This line doesn't touch the columns. > This chart has 2 axis. > > Thanks for any help on this. Hi Martin, I am using 2003. I also meant that there is the horizontal axis and 2 vertical axis. The stacked columns have 2 stacks and on top a line which doesn't touch the columns. Hope that makes sense. Thanks for your help in advance. On Apr 19, 4:11 pm, Martin Fishlock <martin_fishl...@yahoo.co.uk.cutthis> wrote: > Hello Jay: > [quoted text clipped - 13 lines] > > - Show quoted text - Jay, First make the stacked column chart. Right-click one of the columns of the series you want to convert to line. Select Chart type in the menu and select Line. You may want to set it to the other value (Y) axis to get it scaled suitably. SignatureRegards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > How do you do a stacked column chart with 2 stacks and 1 line above > the columns plotting values. This line doesn't touch the columns. > This chart has 2 axis. > > Thanks for any help on this. Hi Earl, Thanks! That worked great. I forgot to mention before that the chart I need is a stacked column chart with 2 y axis. Do I use the normal stacked column chart? or is there a better chart for this? I tried using the Line Column on 2 axis chart but I could not stack those columns. Thanks for your help, Jay > Jay, > [quoted text clipped - 16 lines] > > - Show quoted text - Jay, There are only two y axes. If you're already using them both, then probably the only thing left is to scale a series to fit an existing axis. I looked through Joh Peltier's site (he's the charting guru), http://peltiertech.com/Excel/Charts/index.html, but didn't see anything that might help. SignatureRegards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- Hi Earl, Thanks! That worked great. I forgot to mention before that the chart I need is a stacked column chart with 2 y axis. Do I use the normal stacked column chart? or is there a better chart for this? I tried using the Line Column on 2 axis chart but I could not stack those columns. Thanks for your help, Jay On Apr 19, 7:00 pm, "Earl Kiosterud" <some...@nowhere.com> wrote: > Jay, > [quoted text clipped - 17 lines] > > - Show quoted text -
|
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.