 |
 | 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 / April 2007Horizontally Banded Chart Background
Hi, Am following Jon Peltier's tutorial for horizontal colour banding. However when i convert the line graphs to stacked area type the colouring is not appearing per the bands its suppossed to reflect. eg. i have ranges with upper limits 2.5; 5; 7.5;10 and can only get the band correct between 0-2.5 ... what am i doing incorrectly? Lynne Do all the bands appear? If not, have you converted all of the band series to area type? If so, are they simply unfilled? You can format the unfilled bands to be filled. Or are the band spacings incorrect? Using a stacked area type, your data must be the difference between bands (i.e., with bands at 2.5, 5, 7.5 and 10, you need four bands 2.5 high). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Hi, > Am following Jon Peltier's tutorial for horizontal colour banding. However [quoted text clipped - 6 lines] > > Lynne Jon, I can manage only 3 bands not 4 and yes I have converted all the bands to the area type. The lowest band 0 to 2.5 appears correctly The next band spans the series 2.5 to 7.5 and not 2.5 to 5.0 and covers series 5.0 The last band 7.5 to 10 should reflect the data between 10 and 7,5 but covers series 7.5 2.5; 5.0; 7.5; 10 are upper limits and series names i have used. Lynne > Do all the bands appear? If not, have you converted all of the band series > to area type? If so, are they simply unfilled? You can format the unfilled [quoted text clipped - 19 lines] >> >> Lynne It sounds like you are stacking the area series, which means you need to plot the difference between the band's upper limit and the previous band's upper limit. If you do not do this your bands will plot: 2.5 7.5 = 2.5+5.0 15.0 = 7.5+7.5 25.0 = 15.0+ 10.0 which is what you have, but your Y axis stops at 10, so only part of the third band and none of the fourth appear. All four bands should be plotting values of 2.5, so the upper limits are: 2.5 5.0 = 2.5+2.5 7.5 = 5.0+2.5 10.0 = 7.5 + 2.5 An alternative way to think of it is you need your values all to be 2.5: 2.5 = 2.5-0.0 2.5 = 5.0-2.5 2.5 = 7.5-5.0 2.5 = 10.0-7.5 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > Jon, > I can manage only 3 bands not 4 and yes I have converted all the bands to [quoted text clipped - 31 lines] >>> >>> Lynne Thanks Jon., I was doing just what you pointed out. I have now plotted the differences between the 2 bands and have got it right. Thanks for your detailed explanation it has been very enlightening.. Lynne > It sounds like you are stacking the area series, which means you need to > plot the difference between the band's upper limit and the previous band's [quoted text clipped - 64 lines] >>>> >>>> Lynne |
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.