LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.charting,microsoft.public.excel
external usenet poster
 
Posts: 10
Default Progress bar in spreadsheet?

I am creating a spreadsheet where I will have a long list of projects. One
column represents the completion percentage for the project. I'd like to
display this as a progress bar. If the project is 50% complete, I want the
left half of the cell to be colored in. If it is 75% complete, I want the
left 3/4 of the field to be filled in, etc.

I don't mind doing this manually if there is a way to do so, but I figured
there might be some type of control that can do this.

I have seen reports built in accounting packages and "dashboard" or "metric
tracking" applications that do similar visual representations for individual
line items on reports.

Thanks for your suggestions!!

--


RBear3
..


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Progress bar in spreadsheet? RBear3 Excel Worksheet Functions 7 June 19th 08 10:25 AM
Progress Bar Jase Excel Discussion (Misc queries) 0 June 2nd 08 07:45 PM
PROGRESS BAR Ola2B Excel Discussion (Misc queries) 2 July 11th 07 08:13 PM
Progress bar [email protected] Excel Discussion (Misc queries) 1 January 6th 07 01:49 PM
Progress YTD Lance Charts and Charting in Excel 1 March 29th 05 07:16 PM


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"