Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 17th 09, 07:54 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 1
Default Adding checkmarks to an excel spreadsheet

I am trying to set up a chart and instead of using "yes" or "no" for answers,
I'd like to be able to use checkmarks. Is that possible?

  #2   Report Post  
Old September 17th 09, 08:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2,722
Default Adding checkmarks to an excel spreadsheet

Certainly. You can either use the checkboxs from the forms toolbar, and link
each one to a cell for tabulation, or you can *fake it* by using the
Wingdings2 font. The capital letters O through T procude checkmark-ish type
symbols. For tabulation, you can then do some COUNTIFs.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Davscober" wrote:

I am trying to set up a chart and instead of using "yes" or "no" for answers,
I'd like to be able to use checkmarks. Is that possible?

  #3   Report Post  
Old September 17th 09, 10:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Adding checkmarks to an excel spreadsheet

See this:

http://groups.google.com/group/micro...75653838?tvc=2

--
Biff
Microsoft Excel MVP


"Davscober" wrote in message
...
I am trying to set up a chart and instead of using "yes" or "no" for
answers,
I'd like to be able to use checkmarks. Is that possible?



  #4   Report Post  
Old September 21st 09, 01:23 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 95
Default Adding checkmarks to an excel spreadsheet

On Sep 17, 11:09 pm, "T. Valko" wrote:
See this:

http://groups.google.com/group/micro...isc/browse_thr...

--
Biff
Microsoft Excel MVP

"Davscober" wrote in message

...

I am trying to set up a chart and instead of using "yes" or "no" for
answers,
I'd like to be able to use checkmarks. Is that possible?


Hi,
see this in addition: http://chandoo.org/wp/2009/09/15/add-checkbox-excel/

Have fun, cheers
Michael


Reply
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
adding customer logo jpg to excel 2007 spreadsheet problem Stace Excel Discussion (Misc queries) 0 February 5th 09 11:18 AM
Adding a yearly calendar to excel spreadsheet Sharon Excel Worksheet Functions 2 January 11th 08 04:31 PM
Adding new rows to an Excel spreadsheet niletrader Charts and Charting in Excel 0 October 21st 07 10:51 PM
Microsoft office pic manager wont open my pics,only checkmarks... [email protected] Excel Discussion (Misc queries) 1 September 30th 06 08:56 PM
Ticks in cells - Checkmarks in cell - without checkbox sebt Excel Discussion (Misc queries) 0 January 20th 06 10:37 AM


All times are GMT +1. The time now is 05:51 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017