How do I create a line graphs with months labelled in the X-axis?

A

Aisha Khan

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.
 
B

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.
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Plotting Graph with dynamic table 3
Line Chart - Problems with labeling X-Axis 3
Getting the graph style I want 4
Dynamic series in rows 1
Creating a Line graph 6
Y axis data point alignment with x axis dates 0

Top