 |
 | 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 / General Excel Questions / May 2008Adding a line to my CF column graph - help!
I've figured out how to conditionally format my column graph columns with help from Jon Pelletier's formula. I'd now like to add a line graph to the overall graph to show overall business trending in addition to the site trending in the columns. The existing graph template that allows for column and lines only allows two series for columns and any additional series must be lines. I need to have three series for columns and one for a line. Does anyone know how I can do this? Forget those built-in custom types. They're not very flexible. If you learn to make your own combos, you'll have a lot of power in your pocket. Add the data for the line series to thee chart. Right-click the series, choose Chart Type, and select a line style. Format to suit. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > I've figured out how to conditionally format my column graph columns > with help from Jon Pelletier's formula. I'd now like to add a line [quoted text clipped - 4 lines] > series for columns and one for a line. Does anyone know how I can do > this? Thanks Jon, that worked perfectly. Where would would be the best place to get info on making my own combos? you are right, that would be very powerful! Appreciate all your help with conditional formatting and adding to the graph. Making your own combo chart simply means changing the chart type of an individual series. http://peltiertech.com/Excel/Charts/ComboCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thanks Jon, that worked perfectly. > [quoted text clipped - 4 lines] > Appreciate all your help with conditional formatting and adding to the > graph. |
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.