A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Word/Excel Charts x axis to months



 
 
Thread Tools Display Modes
  #1  
Old October 5th 07, 09:11 AM posted to microsoft.public.excel.charting
Alison
external usenet poster
 
Posts: 27
Default Word/Excel Charts x axis to months

Hi,
I'm trying to format a bar chart which has promotions on the y axis and i
would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08 and
so forth instead of numbers 0-7 but I dont know how to change this? The chart
has bars across according to which month(s) the promotion will be happening
in the next financial year. The chart is currently in word in the document
and connected to data on excel. I'm using microsoft office 2007. anyone help
plz?
Ads
  #2  
Old October 5th 07, 01:07 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 4,393
Default Word/Excel Charts x axis to months

Do you have the data set out like this:
NOV 22
DEC 34
JAN 12
......
Now select all the data and make the chart.
It sounds like you just have a column of numbers (promotions)
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"alison" > wrote in message
...
> Hi,
> I'm trying to format a bar chart which has promotions on the y axis and i
> would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08
> and
> so forth instead of numbers 0-7 but I dont know how to change this? The
> chart
> has bars across according to which month(s) the promotion will be
> happening
> in the next financial year. The chart is currently in word in the document
> and connected to data on excel. I'm using microsoft office 2007. anyone
> help
> plz?



  #3  
Old October 6th 07, 02:25 PM posted to microsoft.public.excel.charting
Alison
external usenet poster
 
Posts: 27
Default Word/Excel Charts x axis to months

Hi, i havent got data like that yet, i've only got a series of promotions and
months that i want to do it in:

Loyalty club program: Feb 2008
Beauty packages: Dec 07-Jan 08
Catalogue: Dec 07-Jun08
etc..etc...

i've seen a bar chart done in another report and i want to do something like
it..where bars go horizontally..according to when the promotion is
happening...
right now i've got the promos on the y axis and on the xaxis 0-7 because the
data was from a sample template of microsoft word 07, except that i've
deleted the numerical data from the excel spreadsheet that comes with it...so
now my chart has the two axis and the grid but no bars going across..the
chart is empty

"Bernard Liengme" wrote:

> Do you have the data set out like this:
> NOV 22
> DEC 34
> JAN 12
> ......
> Now select all the data and make the chart.
> It sounds like you just have a column of numbers (promotions)
> best wishes
> --
> Bernard Liengme
> www.stfx.ca/people/bliengme
> remove CAPS in email address
>
>
> "alison" > wrote in message
> ...
> > Hi,
> > I'm trying to format a bar chart which has promotions on the y axis and i
> > would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08
> > and
> > so forth instead of numbers 0-7 but I dont know how to change this? The
> > chart
> > has bars across according to which month(s) the promotion will be
> > happening
> > in the next financial year. The chart is currently in word in the document
> > and connected to data on excel. I'm using microsoft office 2007. anyone
> > help
> > plz?

>
>
>

  #4  
Old October 6th 07, 03:07 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 6,582
Default Word/Excel Charts x axis to months

You need to show the data in terms of a start date in one cell, and either
an end date or a duration in another, so you can make a floating bar chart.
This type of chart is called Gantt chart, and I wrote a tutorial about
these in Excel:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"alison" > wrote in message
...
> Hi, i havent got data like that yet, i've only got a series of promotions
> and
> months that i want to do it in:
>
> Loyalty club program: Feb 2008
> Beauty packages: Dec 07-Jan 08
> Catalogue: Dec 07-Jun08
> etc..etc...
>
> i've seen a bar chart done in another report and i want to do something
> like
> it..where bars go horizontally..according to when the promotion is
> happening...
> right now i've got the promos on the y axis and on the xaxis 0-7 because
> the
> data was from a sample template of microsoft word 07, except that i've
> deleted the numerical data from the excel spreadsheet that comes with
> it...so
> now my chart has the two axis and the grid but no bars going across..the
> chart is empty
>
> "Bernard Liengme" wrote:
>
>> Do you have the data set out like this:
>> NOV 22
>> DEC 34
>> JAN 12
>> ......
>> Now select all the data and make the chart.
>> It sounds like you just have a column of numbers (promotions)
>> best wishes
>> --
>> Bernard Liengme
>> www.stfx.ca/people/bliengme
>> remove CAPS in email address
>>
>>
>> "alison" > wrote in message
>> ...
>> > Hi,
>> > I'm trying to format a bar chart which has promotions on the y axis and
>> > i
>> > would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08
>> > and
>> > so forth instead of numbers 0-7 but I dont know how to change this? The
>> > chart
>> > has bars across according to which month(s) the promotion will be
>> > happening
>> > in the next financial year. The chart is currently in word in the
>> > document
>> > and connected to data on excel. I'm using microsoft office 2007. anyone
>> > help
>> > plz?

>>
>>
>>



  #5  
Old October 8th 07, 03:09 PM posted to microsoft.public.excel.charting
Alison
external usenet poster
 
Posts: 27
Default Word/Excel Charts x axis to months

Hi Jon,
thanks for the site link..it helped a lot, my chart is pretty much
complete..the only probs i still hav are that for one of the bars for a
campaign from april 08 to may 08 instead of the horizontal coloured bar
filling exactly from the april vertical grid line to the may one, it is
filling just before the april grid line and ending at may, so it looks like
the promotion starts before april (i.e. mid march) or it looks like the bar
is off centre. Can u help?

"Jon Peltier" wrote:

> You need to show the data in terms of a start date in one cell, and either
> an end date or a duration in another, so you can make a floating bar chart.
> This type of chart is called Gantt chart, and I wrote a tutorial about
> these in Excel:
>
> http://pubs.logicalexpressions.com/P...cle.asp?ID=343
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "alison" > wrote in message
> ...
> > Hi, i havent got data like that yet, i've only got a series of promotions
> > and
> > months that i want to do it in:
> >
> > Loyalty club program: Feb 2008
> > Beauty packages: Dec 07-Jan 08
> > Catalogue: Dec 07-Jun08
> > etc..etc...
> >
> > i've seen a bar chart done in another report and i want to do something
> > like
> > it..where bars go horizontally..according to when the promotion is
> > happening...
> > right now i've got the promos on the y axis and on the xaxis 0-7 because
> > the
> > data was from a sample template of microsoft word 07, except that i've
> > deleted the numerical data from the excel spreadsheet that comes with
> > it...so
> > now my chart has the two axis and the grid but no bars going across..the
> > chart is empty
> >
> > "Bernard Liengme" wrote:
> >
> >> Do you have the data set out like this:
> >> NOV 22
> >> DEC 34
> >> JAN 12
> >> ......
> >> Now select all the data and make the chart.
> >> It sounds like you just have a column of numbers (promotions)
> >> best wishes
> >> --
> >> Bernard Liengme
> >> www.stfx.ca/people/bliengme
> >> remove CAPS in email address
> >>
> >>
> >> "alison" > wrote in message
> >> ...
> >> > Hi,
> >> > I'm trying to format a bar chart which has promotions on the y axis and
> >> > i
> >> > would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08
> >> > and
> >> > so forth instead of numbers 0-7 but I dont know how to change this? The
> >> > chart
> >> > has bars across according to which month(s) the promotion will be
> >> > happening
> >> > in the next financial year. The chart is currently in word in the
> >> > document
> >> > and connected to data on excel. I'm using microsoft office 2007. anyone
> >> > help
> >> > plz?
> >>
> >>
> >>

>
>
>

  #6  
Old October 9th 07, 07:16 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 6,582
Default Word/Excel Charts x axis to months

Are the dates correct? It knows that April 08 is April 1, 2008, and not
April 8, 2007?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"alison" > wrote in message
...
> Hi Jon,
> thanks for the site link..it helped a lot, my chart is pretty much
> complete..the only probs i still hav are that for one of the bars for a
> campaign from april 08 to may 08 instead of the horizontal coloured bar
> filling exactly from the april vertical grid line to the may one, it is
> filling just before the april grid line and ending at may, so it looks
> like
> the promotion starts before april (i.e. mid march) or it looks like the
> bar
> is off centre. Can u help?
>
> "Jon Peltier" wrote:
>
>> You need to show the data in terms of a start date in one cell, and
>> either
>> an end date or a duration in another, so you can make a floating bar
>> chart.
>> This type of chart is called Gantt chart, and I wrote a tutorial about
>> these in Excel:
>>
>> http://pubs.logicalexpressions.com/P...cle.asp?ID=343
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "alison" > wrote in message
>> ...
>> > Hi, i havent got data like that yet, i've only got a series of
>> > promotions
>> > and
>> > months that i want to do it in:
>> >
>> > Loyalty club program: Feb 2008
>> > Beauty packages: Dec 07-Jan 08
>> > Catalogue: Dec 07-Jun08
>> > etc..etc...
>> >
>> > i've seen a bar chart done in another report and i want to do something
>> > like
>> > it..where bars go horizontally..according to when the promotion is
>> > happening...
>> > right now i've got the promos on the y axis and on the xaxis 0-7
>> > because
>> > the
>> > data was from a sample template of microsoft word 07, except that i've
>> > deleted the numerical data from the excel spreadsheet that comes with
>> > it...so
>> > now my chart has the two axis and the grid but no bars going
>> > across..the
>> > chart is empty
>> >
>> > "Bernard Liengme" wrote:
>> >
>> >> Do you have the data set out like this:
>> >> NOV 22
>> >> DEC 34
>> >> JAN 12
>> >> ......
>> >> Now select all the data and make the chart.
>> >> It sounds like you just have a column of numbers (promotions)
>> >> best wishes
>> >> --
>> >> Bernard Liengme
>> >> www.stfx.ca/people/bliengme
>> >> remove CAPS in email address
>> >>
>> >>
>> >> "alison" > wrote in message
>> >> ...
>> >> > Hi,
>> >> > I'm trying to format a bar chart which has promotions on the y axis
>> >> > and
>> >> > i
>> >> > would like the x axis to be months of the year NOV, DEC, JAN 08, FEB
>> >> > 08
>> >> > and
>> >> > so forth instead of numbers 0-7 but I dont know how to change this?
>> >> > The
>> >> > chart
>> >> > has bars across according to which month(s) the promotion will be
>> >> > happening
>> >> > in the next financial year. The chart is currently in word in the
>> >> > document
>> >> > and connected to data on excel. I'm using microsoft office 2007.
>> >> > anyone
>> >> > help
>> >> > plz?
>> >>
>> >>
>> >>

>>
>>
>>



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charts Y Axis FGM Charts and Charting in Excel 1 November 7th 06 04:15 PM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 04:55 AM
X-axis in months? Peter Charts and Charting in Excel 3 February 13th 05 05:55 PM
X-axis in months Peter Charts and Charting in Excel 1 February 11th 05 04:36 PM
"X" Axis in Excel Charts LPS Charts and Charting in Excel 3 January 21st 05 05:49 PM


All times are GMT +1. The time now is 03:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.