A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help with Data (Table) below my chart



 
 
Thread Tools Display Modes
  #1  
Old November 20th, 2003, 03:36 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Help with Data (Table) below my chart

Sharon -

It's nearly impossible to align the data in the worksheet with the
plotted points, but at least they can be in the same relative positions.
I've always put up with this (minor) misalignment, because the
inability to control in-chart data tables is much more frustrating. The
precise alignment is only window dressing anyway, isn't it?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Sharon French wrote:

I have read about the Data Table problems in Charts, and don't see my
problem addressed.

I have twelve months of data in a combination Column/Line Chart.
Underneath each column, I want the data to show. The ONLY problem
with the Excel generated Data Table was that the Legend text was
vertically centered, and the data itself was Top Justified, looking
ridiculous. I found no way to correct that problem.

Based on previous answers I see here, I have tried to use an embedded
chart and just copy my data underneath. The problem I'm encountering
now is that I can't get the data to line up under each month. As I
try to adjust the width of the columns underneath the chart, my chart
keeps re-sizing.

I have seen the answer, "Just copy your data under the chart and
format it however you wish.", but I'm not getting anywhere with this.
Any help will be gratefully received.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.