Possible Solution?

Excel Help for Possible Solution? in Presenting and Reporting Data

Possible Solution?

Rate this: (3/5 from 1 vote)

	Reorder your data like this:  Excel Spreadsheet:   A B C D E F 1      1  2  3  4 2  Series 1  Number of Times  200  250  170  203 3  Series 2  Number of Times  290  210  100  103 4  Series 3  Number of Times  180  220  270  197 5  Series 1  Intensity  10  9  10  8.5 6  Series 2  Intensity  9  13  11  10 7  Series 3  Intensity  14  10  7  9.5 Choose Insert -> Chart -> Custom Types Tab -> (Chart Type) Line - Column on 2 Axes After hitting next, you should be able to enter the entire section into the data range (A1:F7), and change the "Series In" to rows or columns.
	Posted by minchazo on 13 Apr 2010

View Full Post