| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
