> in the text, the x-axis is shifted over by a different amount for each > normally be an issue, but, depending on the number and type of digits > text on the side of the plot pushes the plotarea in. > both identical in size and horizontal position. > In a cheap attempt to elicit some ideas, I decided to post a picture of > digits, other times 3 or even 4 digits) ![]() > scale, which I need, but this varies (sometimes it might be double > The problem is, as I see it, is that the amount of text on the vertical Which they are the chart objects all line I thought this would just be a matter of setting the chartarea > (i.e., the vertical axes line up when the graphs are stacked down a > I've got a bunch of charts on a page that I want vertically aligned > Anyway, an interesting problem to tickle your brains: > Nice site, I'm like the all the stuff you got here! I have developed panel charts as a solution. I'm really not a fan of charts in Excel, they just don't behave :D Plotarea.left seems to have no effect whatsoever, plotarea.insideleft is read-only, and implementing VB code to set the number of significant figures runs into a whole plethora of problems. I really need these to all be aligned perfectly as they share a common x-axis along the bottom (not visible). This wouldn't normally be an issue, but, depending on the number and type of digits in the text, the x-axis is shifted over by a different amount for each graph. But the y-axis label text on the side of the plot pushes the plotarea in. Two graphs, with their chartareas both identical in size and horizontal position. ![]() In a cheap attempt to elicit some ideas, I decided to post a picture of my woes. ![]() I got rid of everything shy of the scale, which I need, but this varies (sometimes it might be double digits, other times 3 or even 4 digits) The problem is, as I see it, is that the amount of text on the vertical axis is pushing the plot area in. Which they are the chart objects all line up perfectly. I thought this would just be a matter of setting the chartarea object in a fixed position. I've got a bunch of charts on a page that I want vertically aligned (i.e., the vertical axes line up when the graphs are stacked down a page). ![]() Nice site, I'm like the all the stuff you got here!Īnyway, an interesting problem to tickle your brains:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |