Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Updating a graph with 2 y axis | Excel Discussion (Misc queries) | |||
How to specify values for X axis in a Graph | Charts and Charting in Excel | |||
2 axis bar graph | Excel Discussion (Misc queries) | |||
How do you do a graph with a second Y axis? | Excel Discussion (Misc queries) |