Line chart

Y

ybriggs

New Member
Joined
Jun 6, 2008
Messages
2
I am working with Excel 2007.
Is there a way to get a line chart to start at zero when my data doesn't start at zero?
My boss wants the data line to start at zero even though the data in the spreadsheet starts at 20.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Try adding a cell to the beginnong of your range and place a 0 in it.

plettieri
 
Upvote 0
Add a zero to an "empty" cell (format font white on white background to "hide") and then set your source data to be =(Sheet1!Z1,Sheet1!A1:A10) for example.
 
Upvote 0
What does that mean? That you want to y (vertical) axis to show a minimum value of 0? Or something else?
ybriggs said:
I am working with Excel 2007.
Is there a way to get a line chart to start at zero when my data doesn't start at zero?
My boss wants the data line to start at zero even though the data in the spreadsheet starts at 20.
Click to expand...
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
Line on the Y Axis of my chart that I cannot remove
Replies
3
Views
399
awoohaw
awoohaw
T
  • Solved
Setting Custom Data Labels for DonutChart
Replies
6
Views
160
Kaper
Kaper
S
  • Question Question
Pivot Chart Question
Replies
1
Views
132
Sergius
S
F
  • Question Question
PivotTable Line Chart remove zero value
Replies
0
Views
248
FGaxha
F
B
  • Solved
Copy and paste range that includes charts
Replies
1
Views
119
BuJay
B

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top