Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta

Scale excel problems watch

Announcements
    • Thread Starter
    Offline

    19
    ReputationRep:
    Basically i've got to create a spreadsheet (done) and add the data into the graph. The data on the y axis has a scale that varies alot e.g from 0.1 to 80, most of the data is between 0 and 1 but some of the data goes to 80.

    I have done a log scale on excel to create the graph, problem being that the scale does not go to 0. I need to put these 0 values in! Is there anyway to create a logarithmic like scale on excel but include 0 values?
 
 
 
Poll
Do you agree with the proposed ban on plastic straws and cotton buds?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.