Home

Excel Chart Area Size Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-331157%22%20slang%3D%22en-US%22%3EExcel%20Chart%20Area%20Size%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331157%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20stacked%20bar%20chart%20in%20Excel%202016%20containing%202%20data%20series%2C%20with%208761%20rows%20of%20data%20in%20each%20series.%20The%20vertical%20axis%20data%20comprises%20dates%20and%20times%20(in%20two%20separate%20columns).%20The%20current%20height%20of%20the%20chart%20area%20is%26nbsp%3B4636.28%20cms.%20At%20this%20setting%20however%2C%20it%20stops%20showing%20my%20data%20points%20at%26nbsp%3B%20row%205638%20(out%20of%208761).%20If%20I%20alter%20the%20height%20to%202984%20cms%2C%20all%20the%20data%20points%20appear%2C%20although%20they're%20smaller%20in%20height.%20The%20Height%20field%20tells%20me%20that%20I%20should%20be%20able%20to%20enter%20a%20value%20of%20up%20to%205963.92%20for%20the%20chart%20area%2C%20but%20it%20doesn't%20seem%20to%20want%20to%20allow%20anything%20larger%20than%202984%20without%20screwing%20up%20my%20data.%20See%20the%20photos%20for%20a%20sample%20of%20what's%20going%20on.%20Id%20like%20to%20be%20able%20to%20size%20the%20chart%20area%20so%20that%20each%20of%20the%20bars%20lines%20up%20with%20it's%20corresponding%20row%20on%20the%20worksheet%2C%20but%20I%20can't%20make%20this%20happen%2C%20as%20it's%20not%20displaying%20it%20correctly%20beyond%20row%205638.%20I'm%20using%20Excel%202016%20on%20a%20Windows%2010%20PC.%20Any%20help%20would%20be%20greatly%20appreciated.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F72006i218B0380EFB93117%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20bar%20graph.png%22%20title%3D%22Excel%20bar%20graph.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-331157%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
KimRichmond
Occasional Visitor

I have a stacked bar chart in Excel 2016 containing 2 data series, with 8761 rows of data in each series. The vertical axis data comprises dates and times (in two separate columns). The current height of the chart area is 4636.28 cms. At this setting however, it stops showing my data points at  row 5638 (out of 8761). If I alter the height to 2984 cms, all the data points appear, although they're smaller in height. The Height field tells me that I should be able to enter a value of up to 5963.92 for the chart area, but it doesn't seem to want to allow anything larger than 2984 without screwing up my data. See the photos for a sample of what's going on. Id like to be able to size the chart area so that each of the bars lines up with it's corresponding row on the worksheet, but I can't make this happen, as it's not displaying it correctly beyond row 5638. I'm using Excel 2016 on a Windows 10 PC. Any help would be greatly appreciated.Excel bar graph.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 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