I am looking to see the Chart axis lines through a colored bar or area chart. There seems to be an option for transparent fill but its always greyed out.
Thanks. However, not quite what I'm looking for. Choosing NONE reduces the area to an empty box and defeats the purpose of the area chart. I'd like to see transparent color that allows the grid lines to be seen.
Russ
I would like to create an Excel Area chart with a transparent fill so the grid lines can be seen. The "Transparency" option under fill effects is unavailable when I format the series.
Alternatively, is it possible to display the grid lines in front of the series bars, area, etc...
hassified,
I got the above code to work fine. Set A1 to C,
A2 to 3 and A3 through A12 the numbers 1 through 10. When you run the macro you get the 120 possible combinations of the numbers 1 through 10 taken 3 at a time in column 1.
Now for the range of 1 to 49 taken 6 at a time the number of...
Final update.
Everything now conforms to expected sizes, about 900KB per sheet. Problem was created when I copied a single sheet from a larger workbook to a new, single sheet workbook. Removing VBA inserted calculations (with copy|paste values) the problem seems to have disappeared. I haven't...
You may be on to something here. The sheets are created by VBA code in another workbook and nothing is deleted in the process. However, if I copy|paste the entire sheet into a new workbook, rather than move or copy, everything looks exactly the same, formating, column widths, even the chart...
Good thought. When I remove the imbedded chart each sheet gets smaller by 4K bytes. Restoring all the formating to General, no fill, no borders, automatic font color, default column widths and row heights each sheet gets smaller by 3K bytes. The saved file is still 11,978,762 bytes with one...
Thanks for the follow up.
Copying or moving the sheet to a new file has the same result. The first sheet in the workbook creates an 11MB file and supsequent sheets add 900,000 bytes.
Basic arithmetic: 6002 rows, 137 columns, 1.1 characters per cell is just about the right size. The sheet is...
I don't disagree with you, however if I duplicate the sheet so that there are two identical sheets, chart and all, the file size increases by only 925,000 bytes. So, the puzzle is, if each sheet is 925,000 bytes where did the other 11 million bytes come from?
When I repeat your exercise with 6...
I don't disagree with you, however if I duplicate the sheet so that there are two identical sheets, chart and all, the file size increases by only 925,000 bytes. So, the puzzle is, if each sheet is 925,000 bytes where did the other 11 million bytes come from?
Thanks for the tip sheet.
Using "clear|all" on the unused rows and columns saved an additional 1536 bytes. The file is still 11,984,384 bytes when saved.
Cuting the chart and pasting as a picture (enhanced metafile) increased the size of the file by 46,080 bytes. The cut took forever...
I have a one page workbook with 6002 rows, 137 columns, considerable formating and a single chart that when saved is 11,985,920 bytes? The page was created by a macro. Duplicating the page increases the file size by 902,920 bytes. Removing the chart saves 4096 bytes and removing all formating...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.