|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 21st, 2006, 12:20 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting A Target
I have dynamic column charts that basically chart performance in a particular
area. I have the graphs looking and operating fine, but I need to display a second series of columns showing the possible score. There is only one cell on the datasheet that contains this information. Is this possible and how do I do it? I don't want the people who update the sheet to have to type the possible scores each time! Currently, x axis is individual person, y axis is score. 
|
|
#2
February 21st, 2006, 12:52 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plotting A Target
Hi,
To create another series of columns you will need repeated values. Can you not link this cells back to the one cell that changes. For example A1 contains the single value. The second series of columns is on the range D2  4. So use the formulaD2: =$A$1 D3: =$A$1 D4: =$A$1 Cheers Andy JDB wrote: I have dynamic column charts that basically chart performance in a particular area. I have the graphs looking and operating fine, but I need to display a second series of columns showing the possible score. There is only one cell on the datasheet that contains this information. Is this possible and how do I do it? I don't want the people who update the sheet to have to type the possible scores each time! Currently, x axis is individual person, y axis is score. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#3
February 21st, 2006, 12:52 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Plotting A Target
One way would be
Adding a horizontal line to a chart http://www.tushar-mehta.com/excel/ch...traight_lines/ In that example, I plot the average of the data set. You would replace the reference to the average with the cell that contains the possible score. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have dynamic column charts that basically chart performance in a particular area. I have the graphs looking and operating fine, but I need to display a second series of columns showing the possible score. There is only one cell on the datasheet that contains this information. Is this possible and how do I do it? I don't want the people who update the sheet to have to type the possible scores each time! Currently, x axis is individual person, y axis is score.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Format cells with a formula (7 conditions). | danindenver | General Discussion | 3 | January 2nd, 2006 02:40 PM |
| Return Numerical Label for LAST value Subtracted to reach Sum Target Value | Sam via OfficeKB.com | Worksheet Functions | 17 | October 31st, 2005 01:46 PM |
| Setting traffic lights based on todays date against target dates | HDV | General Discussion | 2 | September 14th, 2005 12:05 PM |
| Splitting a Target Figure | oldgit99 | Worksheet Functions | 3 | August 23rd, 2005 02:50 PM |
| Re Target Times | Bill | Worksheet Functions | 1 | August 3rd, 2004 01:01 PM |
Linear Mode
