Nokia C3: How to start Excel chart at zero

How to start Excel chart at zero
I have a chart that shows shipped quantities vs month/year date, with the date on the x-axis. My manager, who is expert at finding trivial things for me that take up hours to accomplish, asked me to make the leftmost data point Jan 2009, and to make the graph series line intersect with the y axis - currently, there's a small gap between the y axis and the graph series line. There is an option in Excel to do this: Format Axis, followed by Horizontal Axis Crosses: Set Axis Label, which is completely busted - when I force the axis to begin on Jan 2009, it decides to begin on Jan 2010. Aside from getting a new manager, any suggestions?
Reply With Quote
#2
Old 05-01-2012
Shurod Shurod is offline
Member

Join Date: Aug 2011
Posts: 599
Re: How to start Excel chart at zero
Create chart (I have chosen a column chart), right-click format on the y-axis selection axis, axis options at the desired levels of car on the hard setting (minimum 0, main interval 10) to change, then if chart type. If you have not created the diagram, mark the X-axis (where the curve starts at 1), right click - format axes, Scaling - uncheck "value axis crosses between categories" at. It could not without a series of tables - Excel charts its parameters relate principally from a table. A direct input is not possible.
Reply With Quote
#3
Old 05-01-2012
Panop Panop is offline
Member

Join Date: Aug 2011
Posts: 460
Re: How to start Excel chart at zero
You can click on the column labeled "0" on the graph (note:. Caution Do not click on the number "0", but on the next point, if you click directly on the "0", it does not work), and Although with the right mouse button. This will open a context menu. There you can choose "Format Data Series" and then the tab "Data Labels". Click here before "No". Then the "0" is no longer displayed. You can separate the label for each part of the column on or off. Practical Tip: If you are the "pillar" with the "0" can not get good with the mouse to press the right mouse button there, enter for a temporary column to another value, eg "100". Then click the "Data Labels", "None" and then set the value to "0". The "No" then remains for the "0" is received.