logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Using arrows and other shapes as columns / bars in Charts in Excel

March 20, 2015 1 comment Article Easy, Excel, Microsoft Office

Nice quick one.

If you want to use a shape on a chart, in place of columns and bars, it’s possible to do this in Excel.

It’s not obvious how to do it, but is very simple and very quick.

Create your chart as normal. Once you’re happy, elsewhere on your screen, create the shape you want to use.

(INSERTàSHAPES)

Format the shape colours / fill etc as desired.

Now, select your shape. Press [CTRL]+C to copy the shape.

Select your data series on your chart, so all values are selected.

With the values still selected, press [CTRL]+V to paste the shape onto the chart.

 

Easy!

Related

Tags: Charts, Excel, Formatting, Office

1 comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Showing a Picture Based on the Value of another Cell in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Showing Data Bars as a 'Proportion to Total' in Excel
Format or Remove Borders from a Slicer or Timeline in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Using the same Named Range in multiple worksheets, but with different values, in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2021 - Theme by ThemeinProgress