 |
 | 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 / December 2005Can I overlap only two of four data series in Excel Column Chart?
I'm trying to show a range on two of the four data series. Currently if I selected data series and overlap then it will overlap all four data series. Perhaps you want a stacked column chart. The bottom value in the stack would be the minimum value of the range, and the top would be the max minus the min. Format the bottom element to hide it (no border, no area fill), and the remaining stacked item floats from the bottom to the top of the range. Check the link below for more information. Floating column charts: http://peltiertech.com/Excel/Charts/FloatingColumns.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > I'm trying to show a range on two of the four data series. Currently if I > selected data series and overlap then it will overlap all four data > series. |
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.