0

I have a lot of data in Excel in the following format:

 column1    column2    column3 
 date       hour       variable

I want to make a two dimensional chart: time on the X-axis / date on the Y-axis, and colour the chart lines to correspond with the variable values.

I need to do this with data from several years so can anyone suggest how to automate this please?

Improve this question
1
  • You could add extra columns - one per color. Use the Excel function IF to fill the extra column cells with either blank or a number depending on whether a given data value should have the color assigned to the column.
    – Axel Kemper
    Apr 1, 2013 at 12:38

1 Answer 1

Reset to default
0

@Axel Kemper seems to have a viable solution, provided blank is replaced with say #N/A (to avoid discontinuities in the lines). However, this may be a case for a 3D chart because using an XY (Scatter) chart with Straight Lines and Markers does not appear to very likely to be a great aid to visualisation:

SU576330 example

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .