In Excel2013, I'm trying to generate a graph from this table.
8MDLnAv.jpg
It turns out like this.
ujTHviH.jpg
This is almost what I need however there is an unnecessary whitespace for every blank cell. It's more obvious when you look at the ref bars. I suppose Excel is creating a column of height 0 for every blank cell. I really need to change this behaviour and remove those empty columns.
Can somebody help me?
To attach a Workbook
(please do not post pictures of worksheets)
- Click Advanced (next to quick post),
- Scroll down until you see "Manage Attachments",
- Click that then select "add files" (top right corner).
- Click "Select Files" find your file, click "open" click "upload"
- Once the upload is completed the file name will appear below the input boxes in this window.
- Click "Done" at bottom right to close the Attachment Manager.
- Click "Submit Reply"
Ben Van Johnson
Hi and welcome to the forum
If the data you are plotting is from a formula, modify the formula to produce #N/A for the blank cells.
Either that or hide the rows with the blank cells
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks