Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following data and the area graph with column2 and column3 is given below. I want to include the first column into the graph by partitioning the graph(using vertical lines probably or different colors) as modela, modelb, modelc. What is the best way to do this?

                           Date Manufactured
ModelA      10:05:28 AM 12/14/2011 06:21:05 PM
ModelA      10:06:29 AM 12/15/2011 12:46:21 PM
ModelA      10:07:29 AM 11/12/2011 12:46:21 PM
ModelB      10:10:29 AM 10/10/2011 12:46:21 PM
ModelB      10:11:30 AM 09/14/2011 12:46:21 PM
ModelC      10:12:29 AM 11/11/2011 12:46:21 PM
ModelC      10:14:39 AM 12/14/2011 12:46:21 PM

area graph with column 2 and column 3

share|improve this question

1 Answer 1

Change your series to be models instead of "Date Manufactured". This should give you three colors in the legend on the righthand side, one each for ModelA, ModelB, and ModelC. You can then configure the way the series are displayed.

share|improve this answer
    
could you elaborate on what you mean by "Change your series to models"?. DateManufactured is the chart title. –  Sriram Subramanian Dec 23 '11 at 6:16
    
If you right click on the blank area on the chart and select Select data from the menu, you can define multiple data ranges. These will be graphed together. You might have to have a common set of horizontal axis labels, though. –  Darth Android Dec 23 '11 at 6:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.