Graphing data with compliance limit
Currently I graph data from laboratory tests with results in the y-axis and
dates in the x-axis. I then create another series to display the compliance level for the test over the same time period. To achieve this I need to create another column on my data sheet to include the compliance result in each row. Is it possible to have the compliance figure in a single cell on my data sheet, yet still display the compliance level on my graph together with my data points? |
Graphing data with compliance limit
yes, calculate the compliance level putting the figure in, say, cell A1 Do your chart as normal Highlight your chart and in the formula bar type = then go to cell A1 and press return, and locate, format as desired You now have a permanent link even when you amend your data -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=554866 |
All times are GMT +1. The time now is 04:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com