Graphing date related data-points

T

Tom

Excel 2003 SP2
WinXP Pro SP2

I have an Excel spreadsheet with about 4000 rows and 52-ish columns. The
top set of rows 1-13 are descriptive in nature. The general format of the
spreadsheet is
A: Day of week (Monday-Friday etc)
B: Actual date
C-E: Captured data
F: Useable Calculated Data (formula #1)
G-I: Calculated Data
J: Useable Calculated Data (formula #2)
K-L: Calculated data
M: Useable Calculated Data (formula #3)
O-Q: Calculated Data
R: Useable calculated data (formula #4)
etc...
What I'd like to do is to see a graph whereby the Y-axis is related to the
Useable Calculated Data and the X-axis is the Actual Date (Column B). Some
of the useable calculated data varies from 0-1 (something akin to
probabilities) and some of the Useable Calculated Data varies from 0-5 (a
smoothing calculation). So a dual Y-axis representation with colors assigned
to the various Useable Calculated Data columns would be very helpful here.
That is, the left Y-axis could be 0-1 based and the right Y-axis could be 0-5
based. If this isn't such an easy or good idea, then I'll deal with it. I'm
attempting to see the data displayed in a flowing 'sine-wave' format and to
determine if the peaks and valleys coincide in the Useable Calculated Data
columns.
TIA!!!
 
J

Jon Peltier

Select any cell and start the chart wizard. In step 1, choose a line chart
if the data occurs at most once per day, or an XY chart if it occurs more
frequently. In step 2, on the Data Range tab, clear the Data Range box, then
click on the Series tab. The list of series should be empty. Click Add, then
type a name (or select a cell with the name), select the times for Category
Labels or X Values, and select the first usable calculated data field for Y
Values. Repeat for the other three calculated data fields.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top