ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a line graphs with months labelled in the X-axis? (https://www.excelbanter.com/charts-charting-excel/11435-how-do-i-create-line-graphs-months-labelled-x-axis.html)

Aisha Khan

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.

Barb Reinhardt

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.




Tushar Mehta

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.



All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com