Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

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