ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Y axis data point alignment with x axis dates (https://www.excelbanter.com/charts-charting-excel/231758-y-axis-data-point-alignment-x-axis-dates.html)

Gary Pierce

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


All times are GMT +1. The time now is 10:45 AM.

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