Stacked graph overlapping issue

**rexer231** · 05-23-2014, 05:20 AM

Was using a 100% stacked graph to represent data. I have 5 fields in the data

Y coordinate comprises of - English, Science, Maths, Spanish and Total

X coordinate comprises of - Mark, Shelly, Catherine, James, Jenny

need to represent the data, however, depending on the marks, if the marks are very less for Maths, then the bar representation would be very small and the label or figure data would be overlapping and not readable.

Attached is the screenshot circling the issue. Would appreciate it if someone can provide a solution to the overlapping issue.

graph.png

**Kaper** · 05-23-2014, 06:16 AM

Dont draw total on the same graph. Your bars will be immediately 100% higher
If you insist - draw total on secondary axis or as other type of chart - linear with data points only?)
It's a pitty you have not posted sample workbook. After http://www.excelforum.com/forum-rule...rum-rules.html
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Stacked graph overlapping issue

LinkBack

Thread Tools

Rate This Thread

Display

Stacked graph overlapping issue

Re: Stacked graph overlapping issue

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph

[SOLVED] 3 axis chart with stacked bar graph and line graph above

have stacked and overlapping columns in graph?

Cell Overlapping issue?

[SOLVED] Creating a graph similar to a stacked column graph

Bookmarks

Bookmarks

Posting Permissions