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.

 Show quarters and years on x axis of a chart
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Show quarters and years on x axis of a chart

#1
March 18th 05, 01:49 PM
 Kacee external usenet poster Posts: n/a
Show quarters and years on x axis of a chart

Hi,

I have a chart that I want to show both the quarters and years so that I
have 1234123412341234 with the corresponding year below each group.

At the moment it is just showing 123456789101112. Any ideas of how this
could be done
#2
March 18th 05, 07:23 PM
 John Mansfield external usenet poster Posts: n/a

Kacee,

If you are using Excel 2000 or higher, as an example try setting you data up
like this (this example assumes "2000" is in cell A2 and the title "Data" is
in cell C1):

Data
2000 1 5
2 4
3 5
4 6
2001 1 7
2 6
3 5
4 4

Make sure that the years in column A and the quarters in column B are
formatted as text.

A further explanation can be found he

http://www.pdbook.com/index.php/exce...ory_groupings/

----
Regards,
John Mansfield
http://www.pdbook.com

"Kacee" wrote:

> Hi,
>
> I have a chart that I want to show both the quarters and years so that I
> have 1234123412341234 with the corresponding year below each group.
>
> At the moment it is just showing 123456789101112. Any ideas of how this
> could be done

#3
March 18th 05, 08:29 PM
 Kacee external usenet poster Posts: n/a

Will this work on a scatter graph, as again I still get the 123456......

"John Mansfield" wrote:

> Kacee,
>
> If you are using Excel 2000 or higher, as an example try setting you data up
> like this (this example assumes "2000" is in cell A2 and the title "Data" is
> in cell C1):
>
> Data
> 2000 1 5
> 2 4
> 3 5
> 4 6
> 2001 1 7
> 2 6
> 3 5
> 4 4
>
> Make sure that the years in column A and the quarters in column B are
> formatted as text.
>
> A further explanation can be found he
>
> http://www.pdbook.com/index.php/exce...ory_groupings/
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
>
>
> "Kacee" wrote:
>
> > Hi,
> >
> > I have a chart that I want to show both the quarters and years so that I
> > have 1234123412341234 with the corresponding year below each group.
> >
> > At the moment it is just showing 123456789101112. Any ideas of how this
> > could be done

#4
March 19th 05, 03:42 AM
 Jon Peltier external usenet poster Posts: n/a

This will not work on a scatter chart, but make a line chart, then format the series
to have markers but not lines. Looks the same, eh?

To make sure Excel does the category axis the way you want, make sure you have a
label where John has "Data", and the two cells left of that label must be blank.

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

Kacee wrote:

>
> Will this work on a scatter graph, as again I still get the 123456......
>
>
>
> "John Mansfield" wrote:
>
>
>>Kacee,
>>
>>If you are using Excel 2000 or higher, as an example try setting you data up
>>like this (this example assumes "2000" is in cell A2 and the title "Data" is
>>in cell C1):
>>
>> Data
>>2000 1 5
>> 2 4
>> 3 5
>> 4 6
>>2001 1 7
>> 2 6
>> 3 5
>> 4 4
>>
>>Make sure that the years in column A and the quarters in column B are
>>formatted as text.
>>
>>A further explanation can be found he
>>
>>http://www.pdbook.com/index.php/exce...ory_groupings/
>>
>>----
>>Regards,
>>John Mansfield
>>http://www.pdbook.com
>>
>>
>>
>>"Kacee" wrote:
>>
>>
>>>Hi,
>>>
>>>I have a chart that I want to show both the quarters and years so that I
>>>have 1234123412341234 with the corresponding year below each group.
>>>
>>>At the moment it is just showing 123456789101112. Any ideas of how this
>>>could be done

 Thread Tools Display Modes Linear Mode

 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 User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

All times are GMT +1. The time now is 02:24 AM.