Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

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

Intermediate Chart Lesson Excel: 'How to add Custom Markers To Excel Charts'

 

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

How to add Custom Markers To Excel Charts <SEE ALSO CHART TOOLS FOR EXCEL>

When creating a Line or XY-Scatter chart Excel provides a limited set of markers. By using different foreground and background colours you can extend the choice a little.  

    

What you may not know is that it is possible to use clip art or image files.

Create a Line with markers chart using the example data below.

A B
1   Burger Sales (millions)
2 UK 4
3 France 2
4 Germany 2.5
5 Spain 1
6 USA 5

The standard chart will look like this.


You now need to obtain an image to use as the custom marker. For this example we can use one of the clip art images. Use the menu Insert > Picture > Clip art... In the Search for field enter the keyword 'burger'. Choose the image required and insert it in to the workbook.

In order to use the image as a marker we need to copy first copy the image to the clipboard. This is done in the normal way, select the image and use the keyboard shortcut of CTRL+C.

Now select the line series and paste the clipboard contents by using the keyboard shortcut CTRL+V

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 add Custom Markers To Excel Charts Secure Payment Options
Order Type:

OR

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

Order Type:

OR

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
EXCEL VIDEO TRAINING $67.00 YES NO
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
ACCESS/SQL
111+ POWER ACCESS/SQL QUERIES $39.95 YES N/A
 
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

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS