Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Aisha Khan
 
Posts: n/a
Default How do I create a line graphs with months labelled in the X-axis?

I am trying to create a simple line graph with months labelled in the X axis
and the frequency of an event noted in the Y axis? How do I do this? I have
turned on the date feature and all of the tick marks are labelled J for
January.
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

I suspect you have multiple observations for January. In order to show
January only once, you'll need to have just one January observation.

"Aisha Khan" <Aisha wrote in message
...
I am trying to create a simple line graph with months labelled in the X

axis
and the frequency of an event noted in the Y axis? How do I do this? I

have
turned on the date feature and all of the tick marks are labelled J for
January.



  #3   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Use the original data as a source for a Pivot Table (and corresponding
PivotChart).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?QWlzaGEgS2hhbg==?=" <Aisha
says...
I am trying to create a simple line graph with months labelled in the X axis
and the frequency of an event noted in the Y axis? How do I do this? I have
turned on the date feature and all of the tick marks are labelled J for
January.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Column Graphs Andy Charts and Charting in Excel 1 February 3rd 05 11:20 AM
Line graphs with null values Darren Hagarty Charts and Charting in Excel 3 January 12th 05 10:02 AM
Plot a line? Set dymanic axis Max min Stan Altshuller Charts and Charting in Excel 3 December 9th 04 09:04 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 07:16 PM


All times are GMT +1. The time now is 09:54 AM.

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

About Us

"It's about Microsoft Excel"