Excel 2007 : Creating graphs in Excel 2007

[WeaverP]

Hello,

Im having a bit of trouble with a graph i am trying to create. When i generate a graph from the data below i get the attached graph. For some reason it just shows a date with one line, when it actually has lots of values for that day.

Does anyone know how to fix/resolve or even know of a better way of generating a graph for the data below?

Thanks,

W

Date Cure Temp.
07/09/2011 189
07/09/2011 190
07/09/2011 190
07/09/2011 190
07/09/2011 190
07/09/2011 191
07/09/2011 191
07/09/2011 190
07/09/2011 190
07/09/2011 190
07/09/2011 191
07/09/2011 190
07/09/2011 190
07/09/2011 192
07/09/2011 190
07/09/2011 190
07/09/2011 189
07/09/2011 188
29/07/2011 186
29/07/2011 185
29/07/2011 187
29/07/2011 187
29/07/2011 185
29/07/2011 186
29/07/2011 184
29/07/2011 184
29/07/2011 185
29/07/2011 185
29/07/2011 186
29/07/2011 186
29/07/2011 184
29/07/2011 185
29/07/2011 185
29/07/2011 185
29/07/2011 185
29/07/2011 186
29/07/2011 185
29/07/2011 185
29/07/2011 184
29/07/2011 184
29/07/2011 186
29/07/2011 185
29/07/2011 185
03/06/2011 185
03/06/2011 186
03/06/2011 185
03/06/2011 185
03/06/2011 185
03/06/2011 186
03/06/2011 185
03/06/2011 185
03/06/2011 185
03/06/2011 186
03/06/2011 185
03/06/2011 185
03/06/2011 185
03/06/2011 185
03/06/2011 187
03/06/2011 185
03/06/2011 185
03/06/2011 186
03/06/2011 185
03/06/2011 185
03/06/2011 185
03/06/2011 186
03/06/2011 185
03/06/2011 186
03/06/2011 185
03/06/2011 185
02/06/2011 186
02/06/2011 186
02/06/2011 185
02/06/2011 187
02/06/2011 185
02/06/2011 186
02/06/2011 187
02/06/2011 185
11/05/2011 190
11/05/2011 190
11/05/2011 190
11/05/2011 189
11/05/2011 190
11/05/2011 190
11/05/2011 190
11/05/2011 191
11/05/2011 191
11/05/2011 190
11/05/2011 190
11/05/2011 190
11/05/2011 191
11/05/2011 192
11/05/2011 189
11/05/2011 190
11/05/2011 190
11/05/2011 191
11/05/2011 190
10/05/2011 190
10/05/2011 189
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 185
01/02/2011 183
01/02/2011 185
01/02/2011 185
01/02/2011 186
01/02/2011 186
01/02/2011 185
01/02/2011 189
01/02/2011 190
01/02/2011 190
01/02/2011 190
01/02/2011 192
01/02/2011 190
01/02/2011 189
01/02/2011 190
01/02/2011 190
01/02/2011 190
01/02/2011 190
01/02/2011 190
01/02/2011 189
01/02/2011 190
01/02/2011 189
01/02/2011 190
01/02/2011 190
01/02/2011 190
01/02/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 191
28/01/2011 191
28/01/2011 190
28/01/2011 190
28/01/2011 191
28/01/2011 191
28/01/2011 190
28/01/2011 190
28/01/2011 188
28/01/2011 188
28/01/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 190
28/01/2011 191
28/01/2011 192
28/01/2011 192

[Andy Pope]

if you do not want the dates plotted as true dates then format the axis to be Text.

[WeaverP]

if you do not want the dates plotted as true dates then format the axis to be Text.

But the issue is, all the data for one date is one line on the bar chart, i would like it to show each value as a different bar for the same day. Is there not a way of changing the way the graph formats the data?

Thanks.

[Andy Pope]

So did you try changing the axis type as suggested?

[WeaverP]

So did you try changing the axis type as suggested?

Ahh, apologies, i was formatting under the wrong sub heading. It works, thanks you :-)

One final thing i wondered if its possible, is there a way to remove duplicated dates on the X axis, so it only shows one 07/09/2011 below the set of bars, and then the next date and set of bars, etc?

Many Thanks.

[Andy Pope]

You can try multi level category lables.

Or a set of category labels where only labels required have a value.

[WeaverP]

You can try multi level category lables.

Or a set of category labels where only labels required have a value.

Hello,

Does that mean i need to go through all my data and delete duplicate dates?

Many Thanks.

[Andy Pope]

Did you look at the example?

For the multi level labels I used formula to display only the first occurance of a date.

[WeaverP]

Did you look at the example?

For the multi level labels I used formula to display only the first occurance of a date.

ahh sorry, i understand now.

Thank you

[WeaverP]

Did you look at the example?

For the multi level labels I used formula to display only the first occurance of a date.

Hello Andy,

Im trying to repeat what you did for another set of data however I'm not getting the lines on the X axis, and in the format options i dont have the 'Multi-level category labels' option like you in your excel workbook.

I select the data, create column 2D graph and get the same visual apart from the options, where am i going wrong?

Thanks.

[Andy Pope]

Does your data series have two columns of data labels selected?

You there is not multiple items to display the option will not be present.

[WeaverP]

Does your data series have two columns of data labels selected?

You there is not multiple items to display the option will not be present.

I used the same formula in your worksheet to pull out one date per month. I selected the values and the date title, held CTRL and then selected the values including the title pressure.

It creates a graph (simliar to the temp graph) but i cant get the X axis correct because im missing the tick box.

Many Thanks,

[Andy Pope]

That did not answer the question. Does the series formula contain a range for the category labels that is more than 1 column wide?

Post latest file if not sure.

[WeaverP]

That did not answer the question. Does the series formula contain a range for the category labels that is more than 1 column wide?

Post latest file if not sure.

Please see worksheet attached.

Thanks.

[Andy Pope]

You do indeed have 2 columns referenced. Trouble is the second column C2:C156 is empty, so Excel helpful excludes this from the chart.

Try adding a space in C2 and you should see the chart react.

[WeaverP]

You do indeed have 2 columns referenced. Trouble is the second column C2:C156 is empty, so Excel helpful excludes this from the chart.

Try adding a space in C2 and you should see the chart react.

Thanks brill, it works :-)

Thank you for your help, ill venture on and attempt to create the final graphs.

[WeaverP]

You do indeed have 2 columns referenced. Trouble is the second column C2:C156 is empty, so Excel helpful excludes this from the chart.

Try adding a space in C2 and you should see the chart react.

One final thing, I'm trying to change the X axis date to dd/mm however when i select that format under the 'number' tab in 'format axis', the values on the graph dont change. Is it because the data I'm using includes a year which must be shown on the graph?