Area Charts

D

DavidZ

I am using an area chart to display data over the past 16 quaters and would like the ends of the chart touch the "Y" axis line. Currently the area chart begins in the middle of "X" axis point Q1. Can anyone help?
 
A

Andy Pope

Hi DavidZ,

Double click the x axis to display the format dialog.
On the Scale tab you need to uncheck the Value axis crosses between
categories.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with area under trendline 0
simple chart 0
Move Chart with Text 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Adding a line to a population bar chart 0
Scatter chart with categories on x-Axis 2
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
How do I make x-axis dates in area chart not start from/drop to ze 5

Top