Results 1 to 3 of 3

100% Stacked Bar Graph with Label in the center of the Plot Area

Threaded View

  1. #1
    Forum Contributor codeslizer's Avatar
    Join Date
    05-28-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003 - 2010
    Posts
    245

    Lightbulb 100% Stacked Bar Graph with Label in the center of the Plot Area

    Hi there Guys,

    Am trying to implement a progress bar type graph showing the actuals VS the projected values for the month. I have met the basic necessity of mine, i.e., to show the comparison - by using a 100% stacked horizontal bar graph. Where the actual versus the projected is represented in a balance. Actual more towards right shows its above the projected ones and towards left more - it shows is within the projections but is lower in numbers.

    My requirement : is to show the ratio (actual / projection) in the center of the graph.
    My Workaround : As of now, am using a textbox from the drawing tab and entering the cell reference to show the ratio in the center. Its manually assigned and aligned to the center for each graph I make for the respective projects.

    My request - is it possible I can use the data label of the graph itself to be aligned to the center of the plot or chart area? If yes, any guidance please. I have attached a sample of what I have done and what I need it to be like. I have a list of over 50-60 projects. For charts, my whole working is manual as of now. For cell reference for the chart, its quite fine and am okay with it, but for setting the reference of each textbox to the corresponding cell is becoming tedious and time consuming.

    Any bright ideas to handle this.. Would be greatly appreciated.
    Attached Files Attached Files
    cOdEsLiZeR - Back after a long break.. Let's sLiZe some more cOdEs!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Multiple Stacked Area graphs, on the one graph ?
    By james928 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-29-2012, 05:04 AM
  2. how to center x-axis data label on column graph?
    By susisu in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-15-2008, 05:34 AM
  3. Replies: 1
    Last Post: 04-11-2006, 12:50 PM
  4. how to center a square plot area in a square chart
    By xppuser in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-11-2006, 04:20 AM
  5. [SOLVED] How to enlarge stacked chart plot area
    By Carole O in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-02-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1