PC Review


Reply
Thread Tools Rate Thread

Create Graph with Data from 2 Cells

 
 
David
Guest
Posts: n/a
 
      4th Dec 2008
I have a spreadsheet that asks users a question, then scores the answers.
There are two groups of questions. At the end of each section (A & B I'll
call them) I get a total. In Group A, the possible range of outcomes is -17
to +17 which is in cell F20. In Group B, the possible range of outcomes is
-15 to +15 which is in cell F40. This column will be hidden.
On sheet2 ( I'd like to give the sheet a name) I have a graph in cells
C3:U19. In cells B3:B19 I have the B range list from 15 in cell B3 to -15 in
cell B19 by units of 2, except there is a 0 in the middle, so it goes 0, 1,
3, 5 up and 0, -1, -3, -5 down. Across the top is the A range list, C2:U2,
and is the same as B numbering except goes to 17.
What I want to do is COLOR the cell where the intersection of the results of
A & B from cells F20 and F40 on SHEET1 occur.
I have labels in Columns A, V and rows 1, 20 that I would like to keep there.
Thanks for any help!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send multi data (Graph/Cell data) to Word doc as 1 item (no cells) =?Utf-8?B?VG9tLUxF?= Microsoft Excel Misc 0 30th Aug 2006 10:10 PM
HOW CAN I CREATE A HISTOGRAM GRAPH FOR MY DATA? =?Utf-8?B?Tk5BTURJ?= Microsoft Excel Worksheet Functions 1 10th Jun 2006 07:35 PM
how to create a graph for this data shaahul Microsoft Powerpoint 2 9th Jan 2005 04:08 PM
linking data to create a graph Brian Microsoft Excel Worksheet Functions 0 19th Apr 2004 07:09 PM
Re: Create Graph from Data Table Hermit Dave Microsoft ASP .NET 0 19th Jan 2004 07:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:21 PM.