line chart that starts at the y-axis

B

bmacias

Board Regular
Joined
Sep 11, 2002
Messages
217
Hi all.

When I do a line chart in Excel it starts plotting in the middle of the first series.

Is there anyway to have it plot from the left-most part. Thus making it look like it start at the y-axis?

Thank in advance.


Ben
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Sort by date Sort by votes
Right-click on the X axis, choose the scale tab and uncheck Value Y axis crosses between categories.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question Question
Excel VBA secondary axis title
Replies
3
Views
479
NdNoviceHlp
NdNoviceHlp
H
  • Solved
Scatter Chart to Show Durations
Replies
2
Views
169
HJay
H
M
  • Solved
VBA Chart Series title with multiple cells
Replies
4
Views
177
mikejvir
M
C
  • Question Question
VBA - Creating a Dashboard with Charts including data changes
Replies
1
Views
277
Jon Peltier
J
P
  • Solved
Line on the Y Axis of my chart that I cannot remove
Replies
3
Views
423
awoohaw
awoohaw

Forum statistics

Threads
1,225,197
Messages
6,183,499
Members
453,165
Latest member
kuldeep08126

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