Chart of book reading speed

%3CLINGO-SUB%20id%3D%22lingo-sub-2663603%22%20slang%3D%22en-US%22%3EChart%20of%20book%20reading%20speed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2663603%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i%20am%20looking%20for%20suggestions%20how%20should%20i%20make%20a%20chart%20in%20Excel%2C%20which%20would%20show%20average%20number%20of%20pages%20i%20have%20read%20on%20certain%20date.%3C%2FP%3E%3CP%3ERight%20now%20i%20have%20this%20data%3A%20number%20of%20pages%20of%20books%2C%20start%20date%20of%20reading%2C%20end%20date%20of%20reading%20-%20from%20this%20i%20have%20calculated%20my%20average%20speed%20of%20reading%20(page%2Fday).%20And%20i%20would%20like%20to%20know%20my%20progression%20during%20certain%20weeks%20and%20months.%20So%20a%20stacked%20column%20graph%20-%20one%20stack%20for%20each%20book%20i%20am%20reading%20at%20the%20time.%20So%20the%20column%20for%20certain%20book%20would%20start%20at%20the%20start%20date%2C%20end%20a%20the%20end%20date%20a%20nd%20the%20height%20of%20the%20column%20would%20be%20the%20average%20speed%20of%20reading%20(pages%20by%20day).%3C%2FP%3E%3CP%3EAny%20tips%2C%20how%20to%20make%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2663603%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-2665706%22%20slang%3D%22en-US%22%3ERe%3A%20Chart%20of%20book%20reading%20speed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665706%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1132022%22%20target%3D%22_blank%22%3E%40Metchik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20description%20is%20a%20start%2C%20but%20you%20must%20realize%20(as%20a%20reader)%20how%20hard%20it%20is%20for%20words%20to%20paint%20a%20complete%20picture.%20The%20best%20way%20to%20get%20specific%20help%20here%20would%20be%20for%20you%20to%20post%20a%20copy%20of%20your%20actual%20spreadsheet%20so%20we%20could%20not%20only%20see%20it%2C%20but%20even%20work%20with%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, i am looking for suggestions how should i make a chart in Excel, which would show average number of pages i have read on certain date.

Right now i have this data: number of pages of books, start date of reading, end date of reading - from this i have calculated my average speed of reading (page/day).

Metchik_1-1629395760098.png

 

And i would like to know my progression during certain weeks and months. So a stacked column graph - one stack for each book i am reading at the time. So the column for certain book would start at the start date, end a the end date a nd the height of the column would be the average speed of reading (pages by day) - something as in the picture.

Metchik_0-1629395582859.png

 

Any tips, how to make this?

3 Replies

@Metchik 

 

Your description is a start, but you must realize (as a reader) how hard it is for words to paint a complete picture. The best way to get specific help here would be for you to post a copy of your actual spreadsheet so we could not only see it, but even work with it.

I updated my post so it should me more clear
Ditto.