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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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
80
awoohaw
awoohaw
F
  • Question
PivotTable Line Chart remove zero value
Replies
0
Views
101
FGaxha
F
K
  • Question
Automating a data table for Actual/Forecast Chart
Replies
7
Views
252
Marius44
M
F
  • Question
Excel Chart - Dynamic Axis
Replies
0
Views
671
felix_k
F
J
  • Question
Graph Gridlines and Axis Ranges Help
Replies
1
Views
64
awoohaw
awoohaw

Forum statistics

Threads
1,214,641
Messages
6,120,685
Members
448,978
Latest member
rrauni

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