Excel Graph

%3CLINGO-SUB%20id%3D%22lingo-sub-3317721%22%20slang%3D%22en-US%22%3EExcel%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3317721%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20have%20a%20question%20regarding%20an%20excel%20graph%20that%20I%20assume%20is%20an%20easy%20fix%2C%20however%2C%20I%20cannot%20figure%20it%20out%20for%20the%20life%20of%20me%20for%20some%20reason!%20I%20have%20attached%20a%20photo%20of%20the%20graph%20that%20I%20am%20working%20on.%20The%20orange%20curve%20corresponds%20to%20the%20primary%20axis%20and%20there%20are%20no%20issues%20with%20that%20one.%20The%20blue%20curve%20I%20had%20data%20that%20was%20showing%20a%20constant%20velocity%2C%20however%2C%20the%20data%20points%20were%20scattered%20so%20I%20needed%20to%20zoom%20out%20in%20order%20to%20see%20the%20flat%20line.%20I%20did%20this%20by%20changing%20my%20bounds%20to%2010%20and%20-2.%20The%20line%20is%20flat%2Fconstant%20around%20-0.25%20and%20I%20would%20like%20to%20show%20that%20in%20a%20clearer%20way%20on%20my%20graph.%20So%20to%20do%20that%2C%20I%20changed%20my%20major%20units%20to%200.25%2C%20however%2C%20that%20gives%20me%20the%2040%2B%20values%20from%20-2%20to%2010%20in%200.25%20increments%20which%20makes%20the%20y%20axis%20very%20crowded.%20Is%20there%20a%20way%20to%20minimize%20the%20amount%20of%20y%20axis%20values%20that%20show%3F%20I%20would%20like%20to%20have%208%20or%20so%20values%2C%20but%20still%20show%20-0.25%20where%20my%20data%20is%20horizontal%20at.%20If%20that%20did%20not%20make%20sense%20feel%20free%20to%20ask%20additional%20questions!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-05-04%20at%207.06.33%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369329i5B0054C20604253B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-05-04%20at%207.06.33%20PM.png%22%20alt%3D%22Screen%20Shot%202022-05-04%20at%207.06.33%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3317721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3321462%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3321462%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381384%22%20target%3D%22_blank%22%3E%40wolfc2290%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20about%20setting%20the%20minimum%20of%20the%20secondary%20y-axis%20to%20-2.25%20and%20the%20major%20unit%20to%201%3C%2FP%3E%0A%3CP%3EOr%20the%20minimum%20to%20-2%20and%20the%20major%20unit%20to%201.75%3C%2FP%3E%0A%3CP%3EOr%20the%20minimum%20to%20-1.75%20and%20the%20major%20unit%20to%201.5%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello! I have a question regarding an excel graph that I assume is an easy fix, however, I cannot figure it out for the life of me for some reason! I have attached a photo of the graph that I am working on. The orange curve corresponds to the primary axis and there are no issues with that one. The blue curve I had data that was showing a constant velocity, however, the data points were scattered so I needed to zoom out in order to see the flat line. I did this by changing my bounds to 10 and -2. The line is flat/constant around -0.25 and I would like to show that in a clearer way on my graph. So to do that, I changed my major units to 0.25, however, that gives me the 40+ values from -2 to 10 in 0.25 increments which makes the y axis very crowded. Is there a way to minimize the amount of y axis values that show? I would like to have 8 or so values, but still show -0.25 where my data is horizontal at. If that did not make sense feel free to ask additional questions!Screen Shot 2022-05-04 at 7.06.33 PM.png

1 Reply

@wolfc2290 

How about setting the minimum of the secondary y-axis to -2.25 and the major unit to 1

Or the minimum to -2 and the major unit to 1.75

Or the minimum to -1.75 and the major unit to 1.5