| Home |
| Search |
| Today's Posts |
|
#1
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
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:D4. So use the formula D2: =$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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| avoiding plotting zero values on graphs | Charts and Charting in Excel | |||
| Return Numerical Label for LAST value Subtracted to reach Sum Target Value | Excel Worksheet Functions | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| Splitting a Target Figure | Excel Worksheet Functions | |||
Linear Mode
