Excel diagram limit 32000

%3CLINGO-SUB%20id%3D%22lingo-sub-2086993%22%20slang%3D%22en-US%22%3EExcel%20diagram%20limit%2032000%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2086993%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone!%3C%2FP%3E%3CP%3EI%20have%20electric%20measurement%20data%20in%20each%20minute.%20That's%20the%20value%20of%20the%20counter%2C%20that%20is%20monotonously%20growing.%20I%20want%20to%20create%20a%20diagram%20for%20a%20month.%20The%20problem%20is%20that%20there%20are%2042%2C300%20minutes%20in%20a%2030%20day%20month%2C%20and%20the%20limit%20of%20the%20diagrams%20is%2032%2C000%20dots.%20In%20fact%20I%20don't%20need%20so%20many%20dots.%20What%20I%20need%20is%20the%20difference%20of%20the%20counter%20in%20every%2015%20minutes.%20Is%20there%20any%20formula%20to%20calculate%20the%20difference%20of%20every%2015th%20lines%3F%20Please%20help!%20THX%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2086993%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi Everyone!

I have electric measurement data in each minute. That's the value of the counter, that is monotonously growing. I want to create a diagram for a month. The problem is that there are 42,300 minutes in a 30 day month, and the limit of the diagrams is 32,000 dots. In fact I don't need so many dots. What I need is the difference of the counter in every 15 minutes. Is there any formula to calculate the difference of every 15th lines? Please help! THX

0 Replies