Avail 20% discount on updated CA lectures for Dec 21 .Use Code RESULT20 !! Call : 088803-20003

ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer)     04 July 2013

How to create a column chart with background image in excel

How to create a column chart with background image in Excel ?

 
 
 
 
How to create a column chart with background image in Excel ?

Step 1: Arrange the data.

Arrange the data like this.

Arrange data like this - column chart with background image in Excel

Step 2: Create a column chart

Select the data, insert a stacked column chart (why not a regular column chart?, you will understand in a minute).

You will get this.

Create a simple column chart -  - column chart with background image in Excel

Step 3: Set up image as background for chart’s plot area

Select chart’s plot area. Press CTRL+1.

Choose picture or texture fill and select the file with image you want.

Fill chart's plot area with an image -  - column chart with background image in Excel

Step 4: Add dummy max-series

In your data, add a column which gives the difference between column values & axis maximum. For our test data, I choose 1,400 as axis maximum, so the dummy series values are,

Dummy data series -  - column chart with background image in Excel

Now add this series to chart.

Step 5: Format the chart

Now, we are almost done. Our chart looks like below. We just need to format it.

Final chart before formatting -  - column chart with background image in Excel

  1. Select the columns (any series) and press 1
  2. Adjust gap widtth to 0%
  3. Fill the dummy series with a chosen background color.
  4. Make the data series transparent (fill color = no color)
  5. Add borders to data series. Border color should be same as background color.
  6. Adjust the border thickness to 3pts.
  7. Adjust axis maximum to 1,400 (or any value you have selected in Step 4).
  8. Remove grid lines, legend and any un-necessary chart fluff.

Your column chart with background image is ready!

Finalized column chart with background image made using Excel

 



 6 Replies

Divya Shah

Divya Shah (Article Assistant)     04 July 2013

WOW.. AMAZING .

KEEP SHARING. :)

 

Varsha

Varsha (Student)     04 July 2013

Originally posted by : Divya Shah

WOW.. AMAZING .

KEEP SHARING. :)

 

Sathish M

Sathish M (Management Accountant)     04 July 2013

Thank You sir for this lovely educative content.

CA Sanjay Bag

CA Sanjay Bag (CHARTERED ACCOUNTANT)     05 July 2013

THAKS ITS GREAT THING TO LEARN !!!!!!!!!!!!

Rajat Poddar

Rajat Poddar (Qualified CS and CA Finalist)     05 July 2013

very useful... thanxx for sharing...
rakesh

rakesh (IPCC Student)     26 July 2014

yes thanx for sahring 


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Related Threads


Loading
Start a New Discussion

Popular Discussion


view more »







Subscribe to the latest topics :
Search Forum:

Trending Tags