MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Line Graph to Start from zero


Posted by Michael on December 07, 2001 5:02 PM

I'm trying to plot 2 data series using a line chart. However, I want both data series to start from zero, even if both series don't start frim zero. Example
Jan Feb March
Test 1 15 20 35
Test 2 10 12 8
How can can I plot this series with the zero condition. The category label Jan will still start from the first data points (15,10).


Posted by bob umlas on December 07, 2001 10:18 PM

Just select the value axis, choose Format/selected axis, use the scale tab, type 0 in the "minimum" category.