Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Beginner Chart Lesson Excel: 'How to build a combination Column and Line chart'


This course is step-by-step with screen shots and an example Workbook Chart. It first goes step-by-step for Excel 97-2003 users, then Excel 2007+. Also See: Intermediate To Advanced chart Lessons Or All Excel Training <SEE ALSO CHART TOOLS FOR EXCEL>

Excel 2003

When using the Chart Wizard Excel makes assumptions about how your data should be presented within the chart. The range with the most rows or columns will be the Categories and the least rows or columns will be the Series. In the example data below selecting range A1:C13 would result in the Chart Wizard assuming we have 2 Series, 'Units Sold' and 'Revenue', with 12 Categories. The text above each column will be used for the Series name. The first column of data will be used as the Category labels.

Excel 2007+

Excel 2007+does not have a chart wizard as the Ribbon presents all of the major steps directly. Also note that the Format dialog is now modeless, which means when displayed other elements of the chart can be selected and the dialog will automatically update to reflected the newly selected item.

We start the same way by selecting the range we want to chart. Then on the ribbon select Insert tab. The ribbon will now display a Charts group.
Currently Excel does not offer any combination charts so we do have to construct them ourselves.

Secure Payment Options 30 Day Money Back Guarantee & Big Discount for Unlimited License and Resellers License

Single user license =2 users 2 computers| Unlimited user license = unlimited users unlimited computers | Resellers user license = Do anything you like with the add-in, including rebranding and reselling. That is, NO RESTRICTIONS AT ALL.

How to build a combination Column and Line chart Secure Payment Options

Order Type:


Build a combination Column and Line chart + add Custom Markers To Excel Charts

Order Type:


Build a combination Column and Line chart + add Custom Markers To Excel Charts + build a Cluster & Stacked columns chart

Order Type:

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

All Training Comes With Lifetime Free Question Support. Register Here Then Send Your Username & Order Number
Type/Level Cost Instant Download Bundled Savings Option
Excel Training  30 Day Money Back Guarantee
Complete Excel Course Special $59.95 YES N/A
Excel Level 1 Basic Free N/a N/A
Excel Level 2 Intermediate $29.95 YES Yes
Excel Level 3 Advanced $29.95 YES Yes
Excel Tips & Tricks Intermediate-Advanced $19.95 YES No
Excel VBA Training 30 Day Money Back Guarantee
Excel VBA 1 Basic $29.95 YES Yes
Excel VBA 2 (UserForms & ActiveX Controls) $29.95 YES Yes
Working With Excel Sheets In VBA 30 Day Money Back Guarantee      
EXCEL CHARTING (index of courses)  30 Day Money Back Guarantee $9.95 yes yes
EXCEL TRAINING VIDEOS 60 Day Money Back Guarantee
VBA Coding Enhancement tools-basic to advanced vba experience
Code VBA Coding tools added to your Visual Basic editor (VBE) you create better VBA macros faster. Download Demo $99.00 YES No
Smart VBA VBA Development Tool for VBA Programmers. Download Demo $99.00 YES no
Print VBA Code Customizable printing of VBA source code in color with joining indicators $59.95 YES No
Excel Dashboard Learning Kit
Excel Dashboard Reports/Charts 365 Day Money Back Guarantee $49.95 YES Yes
Excel in the Stock Trading Market 30 Day Money Back Guarantee
Build an Automated Stock Trading System $89.95 YES No
Build an Automated Sector Fund System $89.95 YES No
Build an Automated Spread Trading System $89.95 YES No
Build an Cash Flow Valuation Model With Excel with Yahoo! Finance $49.95 YES No
Technical Indicators Library Open Source $89.95 YES No
Excel Finance & Statistic
Finance and Statistics Models $29.95 YES Yes
Random Numbers Generator and Statistics $29.95 YES Yes
Numerical Searching and Option Pricing Models $29.95 YES Yes
Mathematics Aids With Demos
Speed Math for Mind: Speed Mind Maths-details/buy
DreamCalc Graphing Calculator-details/buy
DreamCalc Professional Calculator-details/buy
DreamCalc Scientific Calculator-details/buy
FindDec standard-details/buy | FindDec Professional-details/buy | FindDec Unlimited-details/buy
Aquarius Soft Pocket Binary Converter-details/buy
Aquarius Soft Pocket Currency Calculator-details/buy
Aquarius Soft Pocket Unit Converter-details/buy

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft