LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
porl99
 
Posts: n/a
Default How can I create a chart when double clicking a cell?

Hi - thanks for your help I am very much a novice in Excel but am
trying to learn. I've tried to recreate the worksheet below and what I
want is that when you double click on the person's name (Katie or Jeff)
then Excel prepares a graph showing the scores that that child
achieved. I have bought a book and am trying to teach myself, but
everytime I think I've got the right idea my formulae come back with
errors. If you be kind enough to offer me some assistance - it would
be very gratefully received! Many thanks in advance, Paul

English Maths Science
Katie Autumn 7 7 5 6 7 8
Spring 7 6 6 7 5 5
Summer 8 6 4 6 7 7

Jeff Autumn 6 6 5 6 6 7
Spring 7 7 5 5 6 6
Summer 7 6 6 6 6 6

 
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
How do I create a "backwards" chart Sarah Charts and Charting in Excel 2 March 31st 05 05:08 AM
How do I create a pointer chart, like a speedometer? Ricardo Kozlowski Charts and Charting in Excel 2 March 31st 05 03:23 AM
Create a custom chart, two stacked bars/month w/ two axes? Oscar Charts and Charting in Excel 1 March 21st 05 11:07 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


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

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

About Us

"It's about Microsoft Excel"