You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Excel chart does not start at zero.

Excel chart does not start at zero.

Price: FREE

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,

Visit publisher's web-site: Excel chart does not start at zero.

Category and Tags: ExcelTutorials :

Related Tutorials

How do I start a chart at 150, instead of 0?

Free: Yes
Tags: Excel ›

My data is in the range of 150-250. How do I start my chart at 150, instead of zero? I'm charting data values against dates(months).

Bar Chart 2007 Excel

Free: Yes
Tags: Excel › Charts

Issues Start End Duration Foundation Design 22-Dec-04 23-Aug-06 609
Stone Cladding 16-Nov-04 3-Jul-06 594
Security W & D 4-May-05 15-Dec-05 225
(The 4 columns are Issues, Start, End, Duration)
I want a bar chart with issues on the left side & dates at the bottom.
I would like the bars to start on the start date & extend to the end date.
Is this possible with a bar chart or another type chart?
I cannot get it to work.

xls chart want y axis to start from 72 not zero

Free: Yes
Tags: Excel › Charts

On the y axis of a chart I don't seem to be able to change the y axis values from 0. I would like to change the bottom of the chart to 72 and the upper 120 so that the information is more spread out and looks more meaningful.

Office 2007 Names - Why can't it start with Chart?

Free: Yes
Tags: Excel › Charts

I have a workbook that has range names starting with Chart and other range names that are offset from that one. I'm thinking at least 100 are affected. I know I can write a macro to change the names, and the series that use them, but why can't they start with Chart in Office 2007? This is
going to be a lot of work to update.

How can I create Schedule Chart?

Free: Yes
Tags: Excel › Charts

I have simply an activity list which shows START and FINISH date of related activity. I need to put this information into a Chart, so that I will get a bar chart highlighting the line between the START and FINISH date of the activity.
It is very similar to what we can create in Microsoft Project.
Do you know a specific chart type for this?

Related Applications & Scripts

Start Page : Manage Links and Messages

Free: Yes
Tags: CGI and Perl › Excel CMS

The Start Page Script manages your list of things to do, your favorite links, and any little messages that you've written to yourself. Everything is viewed and updated from a web browser, so it makes a handy start page. It is especially helpful for those who use different computers and different browsers, since everything is maintained in one place.
Start page is an organization tool, similar to a DayTimer for the web. You are always reminded of what you need to get done, which links you need to visit, and you can record your thoughts on the fly without having to open additional applications. This script was originally designed for use by a group of programmers who work together on projects from their respective homes - the page acted as sort of a "message center" where everyone could check in and see what needed to be done.
Because it is so easy to use and install, you can impress your clients when making a web page for them by including Start Page.

Flash Horizontal Bars Chart XML driven - AS3

Free: No
Tags: Flash › Excel Charts

You can configure faster the chart directly from XML file. You can change configuration part
Chart Area:
- x, y position
- width and height of chart
- colors for the chart area background (2)
- vertical margin
- color, thickness and alpha for border...

Flash Horizontal Stacked Bars Chart XML - AS3

Free: No
Tags: Flash › Excel Charts

You can configure faster the chart directly from XML file. You can change configuration part
Chart Area:
- x, y position
- width and height of chart
- colors for the chart area background (2)
- vertical margin
- color, thickness and alpha for border....

Flash Charts Package V2 - XML driven

Free: No
Tags: Flash › Excel Charts

XML driven, completes my personal charts collection. This is an ideal complement for XML Animated Charts Package.
Flash Chart Package V2 includes new charts:
- Doughnut Chart
- Scattered Points Chart
- Bubbles Chart
- Stock Chart
- Horizontal Bars Chart
- Horizontal Stacked Bars Chart
- Horizontal Bars Chart V2
- Horizontal Bars Chart V3

Premium Interactive Multi Charts Compilation XML

Free: No
Tags: Flash › Excel Charts

This file is a nice high-quality value pack worth $66USD. It is a compilation of all our premium multi chart components. The following chart types are included: line chart, area chart, curve chart, stacked bar chart, regular bar chart, wave chart, pie chart, step chart.
All charts can be XML driven. Many parameters can be set. Take a look into the preview to get an impression or visit the components product overview pages.
Components included:
- Multi Bar Chart
- Multi Line/Area Chart
- Multi Pie Chart
- Multi Curve Chart
- Multi Wave Chart
- Multi Step Chart

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing