Excel Charting Problem

  • Thread starter Thread starter Gemini
  • Start date Start date
G

Gemini

I have data in two columns. I've included some of the values (not all, for
the sake of brevity) below.

3.6 0.1
6.4 0.1
7.4 0.2
10.0 0.1
10.4 0.1

The first column is to be plotted on the X axis. I've tried different kinds
of charts (Line and Scatter). However, every value on the Y axis shows up
twice. The Y axis looks like this:

0.3______________________________________
0.3______________________________________
0.2______________________________________
0.2______________________________________
0.1______________________________________
0.1______________________________________

Any idea why this happens? Also, how do I get Excel to stop showing every
marker on the Y axis twice?

Thanks in advance!
 
The problem is with the way the cells are formated on the spreadsheet. You
format is 1 decimal place. Your numbers are .10 and .15. Because of the
formating the Y axis is shown as 1 decimal place. Change the formating of
the cells to 2 or more decimal places and this will solve the problem.
 
Hi Joel! Thanks for your fast and accurate response. It was on the money and
solved the problem. Thanks also from my daughter, as the question pertained
to her school project.

-- Gemini
 
Back
Top