Justify text across multiple columns
I have used Edit, Fill, Justify to fill rows with text within the boundaries
of a set number of columns, but the text in each row is left justified. How
do I justify the text (even spacing) in each row. If I highlight all of the
text (multiple columns and rows) and then select Format, Cells, Alignment,
Justify; Excel jams all the text into the first column. I know I could use a
text box, but I'd prefer not to. Any help would be appreciated. Thanks.
Select the cells you want to center on.
Under Format > Alignment > Horizontal drop down > Center across se...Can I use named range in data range box when creating pie chart?
I have 75 pie charts to create today. Is there a way to use named ranges in
the data range box to speed this up?
Yes. Just type in the name.
Remove 'Junk' from return address.
"BJackson" <BJackson@discussions.microsoft.com> wrote in message
>I have 75 pie charts to create today. Is there a way to use named ranges
> the data range box to speed this up?
Thank you! I was making it too difficult, thinking I needed to include the
Sheet name along with the name range. ...Chart Total
I have a chart which displays 2 suppliers and their spend by month. I want a
3rd line which shows the total spend of these 2 vendors combined however I
cannot figure out a method to do it. Any ideas?
Typically, you would calculate this in the Row Source property of the chart.
If you can't figure out how to do this, reply back with your current Row
MS Access MVP
"Ryan" <Ryan@discussions.microsoft.com> wrote in message
> I have a chart which displays 2 suppliers and th...Line splits across 2 pages
In one of my access reports I have there is one line that splits across to
pages where the top of the letters appear on page 1 and the bottom of the
letters appear on page 2
Any idea why it happens and how to avoid it?
> In one of my access reports I have there is one line that splits
> across to pages where the top of the letters appear on page 1 and the
> bottom of the letters appear on page 2
> Any idea why it happens and how to avoid it?
> Thank you,
Go into design mode and shorten that line.
Joseph Mee...Waterfall Charts
Does anybody have a step by step guide to creating
waterfall charts? I have a training session to run on
wednesday and I haven't got a clue where to start!
Thanks in advance
Here are a couple of resources,
> Does anybody have a step by step guide to creating
> waterfall charts? I have a training session to run on
> wednesday and I haven't got a clue where to start!
> Thanks in advance
Andy Pope, Microsoft MVP...Create an identical Chart Worksheet in Excel 2003
I used the F11 key to create a chart, which inserts just a chart as a
new worksheet and gives it a default name, such as chart 2. My
question is, can I create an identical chart as a new worksheet. This
wouldn't be a copy, rather, a duplicate that is pulling information
from the same location in the entire workbook. The reason I want to do
this is because I currently have data for 12 different series, and
each series has 7 values. What I would like to do is keep the same
chart, but reduce the number of values per series from 7 to just 4.
The easiest way seems to me to be to create ...Macro to sort variable data range fails
Can you please help me identify why this macro is failing with the
Runtime error 1004: Sort method of Range class failed
Row 7 is the header row
Data range has a variable number of rows (so using end(xldown) to
select the range)
Using column BA to select a contiguous range of cells as all cells are
populated in the column
Then using that selection to select entire rows in my list
Sorting as per criteria using row 7 as header row
...More on "Data Range"
This is wonderful for using "OFFSET" for a Dynamic Range Name
for a Chart "Data Range"...http://processtrends.com/pg_dynamic_charts.htm
Thank you again Kelly O'Day.
It includes, for the X-Axis Dynamic Range Name...
"Refers to:" ---> =OFFSET(dyn_ranges!$A$2,0,0,COUNTA(dyn_ranges!$A$A)-1)
Currently, I'm using Column A to receive several Ranges for Charts from
The...COUNTA(dyn_ranges!$A$A) will Count Entries in Column A from Cell
$A$2 down. Other than separating the Ranges...IE..
For Chart 1...Columns A:B ---> COUNTA(dyn_ranges!$...Comparing 2 coulumns in different worksheets and printing the rows that match
Sorry to bother everyone. I am trying to learn some Visual Basic t
maybe make a function that woudl do what i need, but that is goin
slow. What i am trying to do follows.
I have created a perl script that uses the microsft progra
hfnetchk.exe to find what patches are needed on all of our systems her
at work. it gives me a text print out that is tab delimited and
import that into excel on the *Srvneed* sheet. *Column B* in this shee
has the patch numbers for what is needed.
Now our IT security also has a lis...Excel chart data labels showing % change instead of value?
I'm needing to have my excel chart show me the percent change in my 2 series.
I would like this in a data label over series 2 on the chart, but all I can
figure out to do is have the value labeled. Does any one have any
suggestions? I'm believe I'm using Excel 2002.
You can use Rob Bovey's XY Chart Labeler.
"MFritz" <MFritz@discussions.microsoft.com> wrote in message
> I'm needing to have my excel chart show me the percent change in my 2...Animated bar Charts
Anyone know how to take a simple bar chart, with say a value of 10 and
through the press of a button have it animate and shrink in size down
to 5 for example. In other words, I have tons of bars in a "before"
case and also an "after" case and I want a macro or code to show the
transition between those two.
gsimmons2005's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26385
View this thread: http://www.excelforum.com/showthread.php?threadid=...Textbox on chart doesn't print in Office 2003, but does in 2007
I have some charts that I create through C# code on a "template" worksheet
and then copy it over to a new worksheet using the following code. When
looking at the chart.Shapes, I can see the three Textbox objects that I want
and these are the only shapes available. I can see them on the screen in
both Excel 2003 and 2007 correctly. When I print in 2003 though, the
textboxes don't appear like they do for 2007. Can anyone shed some light on
why this might be happening?
// Copy the images and charts (note index starts at 1)
for (int z = 1; z <= wsTemplate.Shapes.Count; ...How to add a second axis to a chart?
I am trying to do a chart with items in Millions and in Units so I need a
second axis. Please help.
You can't select Secondary Axis until a second series is on the chart. Once
you've done that, select Format Data Series and Axis to select the Secondary
> I am trying to do a chart with items in Millions and in Units so I need a
> second axis. Please help.
...How do I resize a worksheet after deleting rows?
After deleting rows in a spreadsheet Excel seems to remember the blank rows,
and will try to print them unless I reset the print area. Also, when I
subtotal the grand totals appear after the blank rows. Is there a way to
re-set the size?
Save the workbook after deleting the Entire rows and before printing.
"Jay Jay" <JayJay@discussions.microsoft.com> wrote in message
> After deleting rows in a spreadsheet Excel seems to remember the blank
> and will try to print them unless I...Protect Worksheet but allow to insert or delete rows
I have set up a worksheet, locked and unlocked cells as needed and I want to
allow the user to insert and delete rows. But, when I set protection and
tick "Insert Rows" and tick "Delete Rows"; the menu only will allow "Insert
Rows", the "Delete Rows" field is not accessible.
Do you get an error message saying that you can't delete the row since there are
locked cells on that row?
I do when I protect a worksheet using your options and then rightclick on a row
number and choose delete. (And that row contains locked cells.)
Bob L Hill...Doing charts in Excel 2000
i am still using the Excel in my Office 200 package. Where can I get udates
to do better charts?
All of the techniques shown here
can be used to make more interesting chart
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"TVG" <TVG@discussions.microsoft.com> wrote in message
>i am still using the Excel in my Office 200 package. Where can I get udates
> to do better charts?
...Returning a Value from Another Worksheet
I have two worksheets in one Excel 2007 file that I'm working with, in which
I want the second worksheet to return values of the first worksheet. Hope I
can explain it clearly here:
The first sheet contains a list of data and numbers to caculate a points
system. For example:
Name Column B Column C Points
Data1 100 5 4
Data2 75 2 1
2) In the second worksheet, I want to be able to input a specific value from
Column A (i.e., I inputted "Data2" from Workshee...how to create a clustered, 100% stacked combination chart
I want to create a chart with 2 100% stacked columns to compare % of 2
Maybe you can use the information here but using 100% stacked columns.
Keri in Vermont wrote:
> I want to create a chart with 2 100% stacked columns to compare % of 2
> different years.
Andy Pope, Microsoft MVP - Excel
...adjusable columns in original dynamics windows
adjusable columns in original dynamics windows, that you can sort on and size
Is there a way to post a screenshot to show you what i'm on about ??
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGr...Combined bar and line chart (two Y axis) how to make excel know which data goes where
after the super fast problem fixing last time i had a problem, i'd like
to ask the excel collective for some more help... :)
now trying to plot a combined bar chart and line graph. I basically
want all the sets of data except one to appear as columns plotted
against the axis on the left and the last set of data (which is a
cumulative value of the data appearing for the columns) plotted against
the right hand axis as a line.
I can plot the graph fine, but out of the 7 sets of data which i want
to appear as 6 sets of columns and one line, i get four sets of columns
and three ...Range name Problem
I have created a range name XYZ23 refering to a column of data in sheet1. On
sheet 2 I typed XYZ23 in cell A3. Why does =COUNT(A3) typed in B3 return a 0
when =COUNT(XYZ23) return the correct count?
"Landmine" <Landmine@discussions.microsoft.com> schrieb im Newsbeitrag
> I have created a range name XYZ23 refering to a column of data in
> sheet 2 I typed XYZ23 in cell A3. Why does =COUNT(A3) typed in B3
return a 0
> when =C...Multiple Worksheets
Operating System: Mac OS X 10.6 (Snow Leopard)
How can I copy same info between worksheets?
You need to be more specific about what you're trying to accomplish... For
what little you've disclosed regular copy/paste will work, but storing
duplicate copies of the same data on multiple sheets [or in multiple
workbooks] is redundant & inefficient. I'm sure you're clear in your own
mind what you're trying to do, but these one-liners do not effectively
convey what you're thinking :-)
Also, it's fine to post multiple questions & use sepa...Add 2nd Y axis in XY scatter chart?
Is there any way to add a second Y axis and then plot data associated with
this axis in an XY scatter chart? If so, what are the steps?
Add your data to the chart then double click the new data series.
On the Axes tab of the format dialog chose Secondary axis.
Don Culp wrote:
> Is there any way to add a second Y axis and then plot data associated with
> this axis in an XY scatter chart? If so, what are the steps?
> Don Culp
Andy Pope, Microsoft MVP - Excel
...How to link data and it's formats bewteen worksheets
I am using Office v.X for mac. I have a workbook that that has master
worksheet with A1:AK4 column headings and A5:AK265 has data with
different formats (date,text,number etc.) I want to create new
worksheet as a diiferent catagories with linking data from the master
worksheet. So when i edit the master worksheet it edits the other
worksheet simultaneous. For example rows 5,15,70,100 belongs to
catagory1 being worksheet2 and rows 10,50,200 being another catagory as
another worksheet and so on. Different rows will make up 6 catagories
in turns 6 worksheets.
I have tried using paste link but i l...i need to create a chart from data from one workbook in another wo
new to excell so please be kind. i need to create a series of charts from
different sets of data in one workbook, and have the charts show in another
seperate workbook, and update automaticly when the data changes in the first
i know how to create charts, its just that i can't get it linking from one
workbook to another
An easy approach would be:
Make the charts in the workbook containing the data. Cut and paste those
charts into a new workbook. The charts are still linked to the original
workbook. If you make changes in the data, the charts...