Home

Pivot Chart X Values

%3CLINGO-SUB%20id%3D%22lingo-sub-674629%22%20slang%3D%22en-US%22%3EPivot%20Chart%20X%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-674629%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I%20have%20data%20like%20such%20in%20the%20image.%20What%20I%20want%20the%20chart%20to%20do%20is%2C%20like%20a%20regular%20chart%2C%20use%20the%20'Lot%2FStrain'%20as%20well%20as%20'Grow%20Room%23'%20column%20as%20the%20series%2C%20and%20the%20'days%20flowering'%20as%20X-axis%2C%20and%20have%20the%20chart%20overlay%20these%20series%20on%20this%20x-axis.%20Purpose%20is%20to%20compare%20different%20conditions%20on%20plant%20growth%20over%20time%20on%20a%20sheet%20where%20I%20will%20be%20continually%20addind%20data%2C%20so%20I%20need%20it%20to%20group%20certain%20values%20as%20their%20own%20series.%20Currently%20it%20awkwardly%20divides%20each%20Lot%20into%20it's%20own%20section%20of%20the%20x%20axis%20and%20subdivides%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20do%20this%20in%20Pivot%20Tables%20or%20do%20I%20need%20to%20use%20another%20method%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20539px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117336i56E7A437CB9CA8D2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Untitled.png%22%20title%3D%22Untitled.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-674629%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
dcormieb
Occasional Visitor

So I have data like such in the image. What I want the chart to do is, like a regular chart, use the 'Lot/Strain' as well as 'Grow Room#' column as the series, and the 'days flowering' as X-axis, and have the chart overlay these series on this x-axis. Purpose is to compare different conditions on plant growth over time on a sheet where I will be continually addind data, so I need it to group certain values as their own series. Currently it awkwardly divides each Lot into it's own section of the x axis and subdivides it.

Is there a way to do this in Pivot Tables or do I need to use another method?

 

Untitled.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies