Urgent Help needed! Graphs!

%3CLINGO-SUB%20id%3D%22lingo-sub-1857199%22%20slang%3D%22en-US%22%3EUrgent%20Help%20needed!%20Graphs!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1857199%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20new%20to%20excel%20and%20don't%20really%20know%20what%20I'm%20doing.%20I'm%20working%20at%20an%20office%20where%20I%20have%20to%20turn%20written%20feedback%20(scales%2C%20short%20answers)%20into%20graphs%20(only%20the%20scales%20into%20histograms).%20I%20need%20to%20find%20a%20way%20in%20which%20I%20can%20simply%20paste%20the%20data%20into%20Excel%20and%20it%20then%20automatically%20creates%20that%20graph%20for%20me%20because%20it%20is%20quite%20a%20lot%20of%20data.%20Is%20there%20a%20formula%20for%20that%3F%20Or%20do%20I%20have%20to%20do%20every%20single%20one%20by%20hand%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1857199%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1892447%22%20slang%3D%22en-US%22%3ERe%3A%20Urgent%20Help%20needed!%20Graphs!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1892447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F858828%22%20target%3D%22_blank%22%3E%40ElenaSarah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou've%20had%20this%20question%20up%20for%20nearly%20two%20weeks%20and%20received%20no%20replies.%20I%20think%20the%20difficulty%20may%20be%20that%20you%20give%20us%20so%20little%20to%20work%20with%2C%20on%20top%20of%20describing%20yourself%20as%20a%20novice%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20a%20bunch%20of%20questions%20for%20you.%3C%2FP%3E%3COL%3E%3CLI%3EHave%20you%20a%20histogram%20producing%20spreadsheet%20now%3F%3C%2FLI%3E%3CLI%3EDoes%20it%20work%20with%20a%20representative%20data%20set%3F%3C%2FLI%3E%3CLI%3EDoes%20it%20work%20satisfactorily%3F%3C%2FLI%3E%3CLI%3EDo%20you%20need%20to%20keep%20a%20record%20of%20all%20the%20datasets%20that%20you've%20graphed%20(for%20possible%20future%20reproduction%2C%20for%20possible%20comparisons%2C%20etc%3F)%26nbsp%3B%20OR%20is%20a%20graph%20once%20produced%20%22past%20history%22%20such%20that%20you%20could%20just%20write%20over%20the%20data%20that%20produced%20it%3F%3C%2FLI%3E%3CLI%3EHow%20does%20the%20%22raw%20data%22%20come%20to%20you%3F%20On%20paper%3F%20In%20electronic%20form%3F%20If%20the%20latter%2C%20is%20it%20always%20consistent%3F%20Is%20it%20in%20Excel%20already%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20start%20with%20those.%20Depending%20on%20your%20answers%2C%20it%20could%20be%20fairly%20easy%20to%20resolve%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20if%20you%20have%20a%20working%20spreadsheet%2C%20attaching%20a%20copy%20of%20it%20to%20your%20reply%20post%20would%20be%20very%20helpful%20to%20any%20of%20us%20here%20desiring%20to%20help.%20Just%20make%20sure%20no%20private%20or%20confidential%20information%20is%20included.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi everyone,

 

I'm new to excel and don't really know what I'm doing. I'm working at an office where I have to turn written feedback (scales, short answers) into graphs (only the scales into histograms). I need to find a way in which I can simply paste the data into Excel and it then automatically creates that graph for me because it is quite a lot of data. Is there a formula for that? Or do I have to do every single one by hand?

 

Thanks!

1 Reply

@ElenaSarah 

 

You've had this question up for nearly two weeks and received no replies. I think the difficulty may be that you give us so little to work with, on top of describing yourself as a novice in Excel.

 

So a bunch of questions for you.

  1. Have you a histogram producing spreadsheet now?
  2. Does it work with a representative data set?
  3. Does it work satisfactorily?
  4. Do you need to keep a record of all the datasets that you've graphed (for possible future reproduction, for possible comparisons, etc?)  OR is a graph once produced "past history" such that you could just write over the data that produced it?
  5. How does the "raw data" come to you? On paper? In electronic form? If the latter, is it always consistent? Is it in Excel already?

 

Let's start with those. Depending on your answers, it could be fairly easy to resolve this.

 

By the way, if you have a working spreadsheet, attaching a copy of it to your reply post would be very helpful to any of us here desiring to help. Just make sure no private or confidential information is included.