Creating chart.

[Joker]

I can't believe I have to ask this question. I have been using Excel for
ages, but for some reason this is eluding me. I want to make a simple bar
chart comparing usage per month. I want each bar to be labeled a certain
month at the bottom. Something like this (I hope this comes through):

U |
S|
A |
G |
E|______________________
Jan Feb Mar

Each time I do it, the months are in the series labels, but they only go in
the legend. When I try and label the series, it puts the date in the chart
on top of the bars to where you cannot read it. What am I missing?

James

 

[Bryan Hessey]

Hi,

In your Chart Opions, Axes, with your Category (X) axis, try setting it
either on Automatic or on Category.

Does this help?

--

 

[Joker]

No, that was the first hing I did, all that does is label to Usage, which is
what the bars are, but each one represents the usage for a particular month.
--
Joker
"...God hath made me to laugh, so that all that hear will laugh with me."
Gen. 21:6

Hello, Bryan!

 

[Bryan Hessey]

Unfortunately I only have one (remaining) Bar Chart, but it does hav
Months across the bottom, which is where I believe you wanted them, an
your 'U S A G E' has been put down the left side, if you compare thi
chart (ignore the scroll bits and period selection) to your chart mayb
you can spot what you require.

File is
http://www.excelforum.com/attachment.php?attachmentid=4632&d=1145027245

HTH

--

No, that was the first hing I did, all that does is label to Usage
which is
what the bars are, but each one represents the usage for a particula
month.
--
Joker
"...God hath made me to laugh, so that all that hear will laugh wit
me."
Gen. 21:6

Hello, Bryan!

+-------------------------------------------------------------------
|Filename: BarChart.zip
|Download: http://www.excelforum.com/attachment.php?postid=4632
+-------------------------------------------------------------------

 

[Joker]

Hello, Bryan!

File is: http://www.excelforum.com/attachment.php?attachmentid=4632&d=1145027245

HTH

Ok, it appears in the very beginning when it asks for the column or rows, I
picked columns and that screwed it all up. It's all good now. Thanks for
the help.

 

[Bryan Hessey]

Good to see, and thanks for the response

--

Hello, Bryan!


Ok, it appears in the very beginning when it asks for the column or
rows, I
picked columns and that screwed it all up. It's all good now. Thanks
for
the help.
--
Joker
"...God hath made me to laugh, so that all that hear will laugh with
me."
Gen. 21:6

 

[vane0326]

I did a quick pivottable for you. Maybe you might get some ideas.


+-------------------------------------------------------------------+
|Filename: BarChart PivotTable.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4633 |
+-------------------------------------------------------------------+

 

[Bryan Hessey]

Unfortunately you did that on my (old) chart, and not on the OP's data.

The pivot table as such makes the Period and the Summary Level more
difficult to select, and although it allows the selection of
non-contiguous periods I did not see that as a requirement nor as a
sufficient advantage, however, if this in any way helps the OP then all
is well.

--