I need to graph rainfall, per minute, on a column chart. All I can get excel to do is create one series with all of the data, when technically speaking, each time/rainfall depth should be its own series. Is there an easy way to get Excel to recognize this fact (other than going in and creating a series for each minute)?

8/31/2010 10:26:17 AM

wtf... can't put a column chart on the secondary axis?!?!!?

excel 2010, btw.

8/31/2010 11:01:40 AM

Are you trying to make a line graph when what you really want is a scatter graph?

8/31/2010 4:40:12 PM

haha, no.

I want a damn column chart and I want it on the secondary axis .

8/31/2010 6:47:31 PM

The only way I can get it to work is to format the x axis data to time, create the column chart, then in the chart if you want it to show the date and time, format the x axis in the chart to show date and time.


What are you trying to add to the secondary axis?

8/31/2010 8:43:48 PM

not sure we are on the same page... I can get the x axis to be date/time, but instead of each date/time & rainfall depth pair being a separate series, I just get one series of the rainfall in one big bar.

I need this to be on the secondary axis, as my primary axis is flow data and by convention, flow is on the primary, rainfall is on the secondary.

8/31/2010 8:52:26 PM

I think I know what you want, is it something like this?



[Edited on August 31, 2010 at 9:04 PM. Reason : pic]

8/31/2010 9:03:55 PM

yeh, close.

specifically, my flow data is a curve connected scatterplot, on the primary axis, with date/time on the x-axis, thus I don't need a stacked column. I'm wanting the rainfall to be on the secondary axis, with date/time on x, and to drop down from the top (just inverting what you have for rain). I know how to do all of this, except to automatically get each date/time & rainfall pair to be a separate series.

I can manually do this, by selecting each date/time & rainfall pair as a separate series... but I don't have the time to do that 10,000+ times


[Edited on August 31, 2010 at 9:11 PM. Reason : .]

8/31/2010 9:07:23 PM

The only thing I can come up with is this. I am sure you have more options in excel 2010, but I only have 2003 at home (I can check 2010 at work tomorrow). This is the Line - Column on 2 Axes




[Edited on August 31, 2010 at 9:37 PM. Reason : forgot the labels]

[Edited on August 31, 2010 at 9:38 PM. Reason : 2010]

[Edited on August 31, 2010 at 9:50 PM. Reason : removed the "t" ]

8/31/2010 9:34:44 PM

yeh, that's pretty much it; I can do the other formatting stuff easy enough... now how can I get my rainfall data in that style column on the secondary axis (the primary/secondary axis options are grayed out for my column... not that I can get the column situation right anyways) without having to define 10,000 series manually?

oh yeh, remove the "t" from your image url

[Edited on August 31, 2010 at 9:39 PM. Reason : .]

8/31/2010 9:38:04 PM

Seems to show you how to do it on 2010, I hope this helps.

http://blogs.msdn.com/b/excel/archive/2007/08/24/combining-chart-types-adding-a-second-axis.aspx

8/31/2010 9:48:22 PM