Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Y axis data point alignment with x axis dates

I have a graph with a Y axis that plots a population number ending each month
for approximately two years. Each month the graph grows with the addition of
a new month's data. The X axis evenly and correctly displays each month
across the bottom of the graph. The problem is that many of the data points
on the Y axis do not align with the corresponding month and fall between
months or the ticks along the bottom of the graph area. Some are on the
mark, some are a little off, and a few are way off. How do I get the data
points to aligh with the month of the X axis along the bottom of the graph so
that the trendline and display is not skewed?
--
Gary Pierce
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
How can I draw a circle on a graph using point data and the axis? Graphically Challenged Charts and Charting in Excel 2 April 3rd 23 10:54 AM
Hovering Over the data point shows different X-Axis Melissa Charts and Charting in Excel 0 February 25th 09 03:46 PM
Data point on line is not over the point/tick in X axis... TomCat Charts and Charting in Excel 2 September 6th 07 01:36 PM
Y2 Axis Labels on Y1 Data Point Brad K. Charts and Charting in Excel 1 June 7th 07 08:38 PM
X Axis Labels every 96th Data Point JonMulder Charts and Charting in Excel 1 May 29th 05 03:58 PM


All times are GMT +1. The time now is 04:58 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"