chart keeps putting the values together on same line

  • Thread starter Thread starter NocturnalLunacy
  • Start date Start date
N

NocturnalLunacy

I am trying to add a chart into my spread sheet but excel keeps putting the
values on the same lines as others. The values are correct as far as what
data is used but it continues to put 3 different lines for one value.
 
Try changing the format of the source data. If you are displaying 1 place
accuacy and your source data in the cells are:

1
1.2
1.4

The cell and the chart will show 1 as the value and it will appear on three
lines in the chart.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set chart series endpoint dynamically 0
PowerPoint Embed scroll excel chart and data in powerpoint 0
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1
Weird issue with very simple line chart - urgent 3
Chart 2 axis 2
Chart Lines 2
Creating a chart with varying data value ranges 1
Line charting the same series using data from multiple sheets? 1

Back
Top