ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with Graph Axis (https://www.excelbanter.com/excel-discussion-misc-queries/111574-help-graph-axis.html)

PaulW

Help with Graph Axis
 
I have a report that I add to weekly, and each new line will be the monday of
that week. Part of the report is a graph that I update, simply by changing
the data the graph uses to include the new row.

So the horizontal axis on the graph is every 7 days (Mondays), but the
problem occurs because I need to have vertical lines on the graph to signify
the beginning of the month.

I've tried setting the axis so a Month is a Major unit, and days a minor,
but it just doesn't work correctly, this means I have to manually draw lines
on the graph, and move them every week. Is there a better way (and more
accurate than my hand) of having vertical lines for the beginning of the
month?


All times are GMT +1. The time now is 07:12 PM.

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