 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 334 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Urgent PLZ HELP QUIZ THIS SUNDAY 4TH JANUARY 2010!!!!Dear Esteemed Excel Experts - I need add a single graph for these 5 different tabs of surveys to show the percentage contribution to each category (See attached file) The Radar Type doesn't work out that well!
PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
use the Groupname and Linked Cell properties via Properties
First of all, happy new year.
The groupnames of the different Correspondents are the same. Therefore the OptionButton's won't work as you would expect to. This is common with copy paste actions.
Next step is to use Linked Cell in the properties. Link each OptionButton to a specific cell and you can use these to create the output you like in excel format.
I would like to upload a changed file in which it works but cannot find the way to do it.
Greetz
Found a way: opened a new topic, look for my file there.
File for Aback's question
Forms OptionButton
Is there a good reason to use embedded form objects?
What about data validation
What about data validation icons
Charts
have you looking into pie charts ?