Spice Up Your Charts With Images Or Shapes As Line Markers.


This tip really is a fun one for spicing up that boring chart for your presentation, some peoples charts really are snoozy, so here is how to pep yours up a little with a few clicks.

First of all create a basic Excel line chart as usual with markers…then if you are using Excel 2007 onwards….

  • On the Insert tab
  • Illustrations
  • Shapes – to add a shape to your worksheet- add it to anywhere on your sheet so you can then
  • Select the shape and hit CTRL+C
  • Activate your chart by selecting it, select the line series and hit CTRL+V

 

If you want to really turn up the volume on your Charts then you can also use Clip Art as line markers as well as shapes

 

Other Excel Tip For Charting

1. Change Your Chart Type In Excel

2. Make All Of Your Excel Charts The Same Size

3. Shorten Y Axis Labels On Your Chart

4. Change The Width Of Bars In Excel Barcharts

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts