Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-873959%22%20slang%3D%22en-US%22%3ECharts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873959%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20I%20have%20a%20pivot%20with%20the%20following%20columns%3A%20customer%20name%2C%20total%20amount%20of%20hours%2C%20expected%20week%20of%20delivery.%20How%20can%20I%20create%20a%20Chart%20with%20weeks%20in%20%22x%22%20%2C%20hours%20in%20%22y%22%20and%20the%20name%20of%20the%20customers%20in%20the%20boxes%20of%20the%20%3C%2FSPAN%3Ehistogram%3F%20thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-873959%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876102%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876102%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414810%22%20target%3D%22_blank%22%3E%40GiadaB%3C%2FA%3E%26nbsp%3B%2C%20can%20you%20mock%20up%20the%20desired%20result%20with%20the%20drawing%20tools%20and%20show%20us%20what%20you%20would%20like%20to%20achieve%3F%20I'm%20having%20problems%20connecting%20histogram%20with%20weeks%2C%20hours%20and%20customers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876244%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876244%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3BHi%2C%20attached%20the%20drawing%20of%20the%20chart%20I%20want%20to%20achieve.%20Thank%20you!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20706px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133585iD29E30D276D74648%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SCAN_20190926_083842636_page-0001.jpg%22%20title%3D%22SCAN_20190926_083842636_page-0001.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-877949%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-877949%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414810%22%20target%3D%22_blank%22%3E%40GiadaB%3C%2FA%3E%26nbsp%3B%2C%20thanks%20for%20the%20mock%20up.%20That%20is%20not%20a%20histogram%20but%20a%20regular%20stacked%20column%20chart.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20data%20needs%20to%20be%20arranged%20with%20customers%20down%20one%20column%2C%20weeks%20across%20the%20top%20(or%20vice%20versa)%20and%20the%20numbers%20in%20the%20grid.%20Then%20you%20can%20select%20the%20data%20and%20insert%20a%20stacked%20column%20chart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20614px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133692i404FE1A76E49588B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-09-27_09-06-50.png%22%20title%3D%222019-09-27_09-06-50.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
GiadaB
New Contributor

Hello, I have a pivot with the following columns: customer name, total amount of hours, expected week of delivery. How can I create a Chart with weeks in "x" , hours in "y" and the name of the customers in the boxes of the histogram? thank you

3 Replies

Hello @GiadaB , can you mock up the desired result with the drawing tools and show us what you would like to achieve? I'm having problems connecting histogram with weeks, hours and customers.

 

@Ingeborg Hawighorst Hi, attached the drawing of the chart I want to achieve. Thank you!SCAN_20190926_083842636_page-0001.jpg

Hi @GiadaB , thanks for the mock up. That is not a histogram but a regular stacked column chart. 

 

The data needs to be arranged with customers down one column, weeks across the top (or vice versa) and the numbers in the grid. Then you can select the data and insert a stacked column chart.

 

2019-09-27_09-06-50.png

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies