microsoft.public.excel.charting Google Group

Chart distorts secondary axis when the x-axis is logarithmic

n...@discussions.microsoft.com (Nemo) — Mon, 04 Jan 2010 21:01:02 UT

I'm trying to create a chart whose x-axis and primary y-axis are logarithmic
and whose secondary y-axis is linear using Excel 2007. No matter how I build
the chart (i.e. three columns at the same time, or adding a series at a time)
as soon as I select logarithmic from the x-axis options the data plotted on

Chart showing different data than listed

gobonni...@discussions.microsoft.com (GoBonnieGo) — Mon, 04 Jan 2010 20:33:01 UT

I'm doing an energy chart for 3 different buildings. Column 1 has the
months, column 2 has the dollar amount is for Bldg 1. Column 3 is for the
dollar amount for Bldg 2 and column 4 ist the dollar amount for Bldg 3.
On the chart, Bldg 1's data shows correctly @ 2300. But Bldg 2's data is
showing 2900 when it should show 530. Bldg 3's data is showing 3500 when it

Charts keep Shrinking

con...@discussions.microsoft.com (Connie) — Mon, 04 Jan 2010 19:54:01 UT

I refresh data every month and some of my Excel charts tied to the data are
shrinking when I go to print them. I'm wasting hours trying to view at 200%
so I can grab a resize handle and reformatting them all.
Please help. Tell me there is an upgrade to fix this glitch!

Chart tabs changing by themself

elar...@discussions.microsoft.com (Elardus) — Mon, 04 Jan 2010 09:25:01 UT

I have an Excel 2007 spreadheet (.xlsx) file with about 40 charts all in
their own sheets.
Every one of those sheets used to have their own descriptive tab name. Excel
does not seem to like that, however, as sometimes after closing, it just
deletes all of my tab names replacing them with a generic Chart3, Chart4,

Issues when pivot charts are refreshed and pivots has filters

saswatomi...@discussions.microsoft.com (Saswato Mitra) — Sun, 03 Jan 2010 05:50:01 UT

Dear Sir,
Need help with pivot charts. The problem I am facing is as given.
Have created a pivot. It has filters, by name and we want to track for each
person productive & non productive hours. One name is chosen and a pie chart
is made and formating done with labels (to display the absolute no. and %).

Chart Stopped Updating

alectri...@discussions.microsoft.com (Alectrical) — Sat, 02 Jan 2010 19:00:02 UT

Hi
I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
Any ideas.
Thanks
Alec

How to show chart only within worksheet?

e...@discussions.microsoft.com (Eric) — Sat, 02 Jan 2010 10:47:01 UT

Does anyone have any suggestions on how to show chart only within worksheet?
I receive a excel file, within a sheet, there is only one chart, and no cell
can be selected in other region.
Does anyone have any suggestions on how it can be done in Excel 2003?
Thanks in advance for any suggestions
Eric

Format Data Labels Doesn't Save

g...@discussions.microsoft.com (GLM) — Thu, 31 Dec 2009 16:42:01 UT

Happy New Year!!!
I have a line chart with one line which represents the average of the values
for other column the the original spreadsheet. I selected one of the data
points on the average line and checked the box to "Add Data Label". The data
label displays the value properly. Then I added a fill color, border color

Daily / Monthly Chart

Thu, 31 Dec 2009 09:56:01 UT

Hi,
Is it possible that I have 2 sets of data, but I can switch between viewing
either of them in 1 chart using a combo box?
Daily Monthly
Column A Column B Column D Column E
3 Jan 2005 1.2590 Jan 2005 1.2090

Regarding Dynamic chart

vmohan1...@discussions.microsoft.com (vmohan1978) — Wed, 30 Dec 2009 16:44:01 UT

Dear All I have problem in formula ans it was solved Mr. Max , now i am
facing problem in Chart please do the needful .
I am mention the my problem and the formula given by Mr.Max .
In cell b1 my input value varies from 1-30
in e1 my input will be amount it varies assume 300000.
i want formula in a5 to show 0 and a6 as 1 so on till i get the input in b1

How to insert 2 scales on y-axis?

e...@discussions.microsoft.com (Eric) — Wed, 30 Dec 2009 14:55:01 UT

Does anyone have any suggestions on how to insert 2 scales on y-axis? one
scale on the left and the other scale on the right.
Thanks in advance for any suggestions
Eric

Reverting to default chart fill colors (in Powerpoint?)

ucdcr...@gmail.com (david rocha) — Tue, 29 Dec 2009 21:21:22 UT

Hi all, I am using Windows XP with Office 2003.
I inherited a Powerpoint file that contains many embedded Excel column
charts, where all columns are a drab gray.
What I'm trying to do is to get each chart back to the default fill
colors, where each column is a different color. Is there a way to do
this all at once (i.e., one operation per chart that would change the

How to get multiple lines on one graph

cari...@discussions.microsoft.com (carisak) — Tue, 29 Dec 2009 18:46:01 UT

I have a data set that consists of pressure readings taken over time for two
rooms. The readings range from -2.5 to +2.5. I want to develop a chart that
has each rooms reading represented by a different line. The y axis would be
pressure and the x axis would be time. I know, sounds simple. However, the

2D Graphs Blending together

(Soulkeeper1987) — Tue, 29 Dec 2009 18:08:01 UT

When ever i make pie graphs in excel 07 the graphs come out correct, but when
i change styles, some of the slice override the others. The main style i
change it to is style 47(black background 3D Look). i have tried remaking the
graphs and it still happens. Also i have tried to select the individual

Move line to front

electricju...@discussions.microsoft.com (Electric Julie) — Tue, 29 Dec 2009 14:06:01 UT

I have three lines over a bar graph and need to move one of the lines to the
front of all other items. I've tried moving it to the top in the dat legend
box and also putting it in a different column in the data.

Showing "NC" in data table

aud...@discussions.microsoft.com (AudPod) — Mon, 28 Dec 2009 21:40:01 UT

I have a bar chart with the data table displayed below. Some of the values
should be showing the text label of "NC" (not computed), but, the table
displays zeros. Can this be resolved?

surface charts in 2-D

sarahju...@discussions.microsoft.com (Sarah Jurak) — Mon, 28 Dec 2009 21:31:01 UT

There are horizontal and verticle lines across the surface chart in 2-D. Can
these be removed. They do not respond to the gridline feature. I have been
unable to find a way to remove them. You can't click on them either.

Fund Raising Chart

samiaut...@discussions.microsoft.com (samiauthor) — Mon, 28 Dec 2009 20:21:01 UT

Does anyone know of a way to create a fund raising chart in Excel? I'm
looking for something like a temperature chart. I want it to be interactive
so when i update the excel spreadsheet it will update the chart.
Any ideas?
Sharon

work with conventional dates for axis scale

g...@discussions.microsoft.com (gkr) — Mon, 28 Dec 2009 20:22:01 UT

How do I scale a time-scale axis using the conventional date format instead
of a date in the mysterious long string of numbers that randomly shows up for
the dates? Why does this change from chart to chart (sometimes conventional
date formatting, sometimes the string of numbers) and how do I change it or

How do I insert benchmark lines into charts?

dwilli...@discussions.microsoft.com (dwilliams) — Mon, 28 Dec 2009 16:46:02 UT

Can you one help me on inserting benchmark lines into excel charts? thanks

Create a Message based on the condition

madhumur...@discussions.microsoft.com (Madhumurthi) — Mon, 28 Dec 2009 14:31:02 UT

I want to create a graph based on the condition. For example i have the
salaries of 10 employees, wanna to display names of the employees along with
the salary and year of joining with the condition salary >$2000
Help me out on this.

How to make odds ratio graph?

Sun, 27 Dec 2009 18:32:01 UT

How to make odds ratio graph?

Data Points Filled In Blue Showing Up With A Red Circumferencial Outline: Why ?

rgs...@notme.invalid (Bob) — Sun, 27 Dec 2009 12:44:45 UT

Hello,
Using Excel 2007
Pretty new at this.
I created a chart from three columns of data.
First column(A) has dates, the next two (B & C) has data.
The generated chart therefore has two linear curves on it.
The Horiz axis is the dates,
One curve is therefore dates vs Column B data
The other curve is dates vs C data.

In Excel 2007 Trendlines

k...@discussions.microsoft.com (KEK) — Sat, 26 Dec 2009 01:36:01 UT

In Excel 97, I could get trendlines as polynomials with exponents from 1 to
6, and I could get exponential too. It looks like Excel 2007 is downgraded
to only exponent 1, which means linear.
Am I right that it is downgraded like this?

Can charts be blownup in Excel 2007?

chandrasekhar...@discussions.microsoft.com (Chandrasekharran) — Fri, 25 Dec 2009 11:54:01 UT

text box

donnachie...@discussions.microsoft.com (donnachieian) — Wed, 23 Dec 2009 22:20:01 UT

how can I increase border thickness on text box

How can I generate a Tag Cloud of words in Excel?

ale...@discussions.microsoft.com (Alex S.) — Wed, 23 Dec 2009 18:45:01 UT

Does anyone know of a plug-in or method to use Excel to generate a 'Tag
Cloud' chart / graphic in Excel?
I export database records to Excel for detailed analysis using pivot tables,
and I'd love to have a way to turn entries in a 'Keyword' field into a tag
cloud. Basically this:
- Read the contents of a column (field) marked Keyword, in a spreadsheet,

Changing Pivot Table Data Source to multiple ranges

tomgar...@discussions.microsoft.com (Tom Garner) — Wed, 23 Dec 2009 16:14:01 UT

In Excel 2007, I just ran out of room on a tab that feeds into several pivot
tables that feed into other daily and weekly reports. I have found the way
to create a pivot table with multiple consolidation ranges, but have not seen
any way to edit the data source of an existing pivot table to include another

Can you change only one cell size in a workbook?

be...@discussions.microsoft.com (Becky) — Tue, 22 Dec 2009 20:28:01 UT

Re: Charting with irregularly spaced x-axis

teylyn.43s...@thecodecage.com (teylyn) — Sat, 26 Dec 2009 08:23:45 UT

Hi,
create the chart with the XY Scatter chart type, then the X axis will
be scaled with the gaps according to the values.
With your data sample Column A = Date, column B = Days from start,
column C = measurement, set up the XY data series with
Series X values =Sheet1!$B$2:$B$5
Series Y values =Sheet1!$C$2:$C$5

How to add another y-axis range into chart?

e...@discussions.microsoft.com (Eric) — Tue, 22 Dec 2009 15:14:02 UT

Does anyone have any suggestions on how to add one scale on right y-axis and
one scale on left y-axis?
Thanks in advance for any suggestions
Eric

Secondary axis help

koolai...@yahoo.com (EAB1977) — Mon, 21 Dec 2009 14:08:30 UT

Hi everyone,
I am having some difficulty in Excel 2007 Charting. I have a stacked
bar chart that I would like to add a horizontal secondary axis on. How
do I do this? I'm trying to do what the Help says but there is
something that I am not getting.
1. I click on the Chart and select the Format Tab
2. In the Current Selection section, there is a Chart Elements drop

charts shrinking to unuseable sizes

marksando...@discussions.microsoft.com (Mark Sandoval) — Mon, 21 Dec 2009 05:12:01 UT

i am in the military and use an excel sheet to track items between myself and
the team based in iraq. the problem is that when we email this sheet back and
forth, all of the charts and graphs shrink so small that we cant read them.
we have tried protecting the sheet, that didnt work. We are useing outlook

Multiple Bar Graphs on one chart

rsc...@discussions.microsoft.com (rscd20) — Sat, 19 Dec 2009 19:48:01 UT

I am trying to combine multiple bar graphs onto one chart
I am trying to display a bar graph to schedule time at my office. Employees
work outside and inside and I would like to display that as 2 different
colors. Unfortunately some work inside and then outside, while other work
outside and then inside. This creates a problem for the series as Excel just

Chart Data Point Size Changing ?

rgs...@notme.invalid (Bob) — Sat, 19 Dec 2009 15:29:04 UT

Hello,
Using Excel 2007
I'm embarrassed to ask this, as it's undoubtedly so simple, but just
can't find out how to do it.
Everything sure was simple in earlier versions !
Anyway, I have a simple chart that I created, linear, with the data
points being shown as squares. Guess it picked the squares on its own,

Can an address list be alphabetized in excel?

kev...@discussions.microsoft.com (kevlev) — Sat, 19 Dec 2009 01:51:01 UT

I am attempting to build an Excel spreadsheet database of address, and I'm
wondering if I can just input the names and address, and have Excel
automatically alphabetize them for me. I've trie the SORT feature (from
A-Z), but this is not working for me.

graphing data

mika...@discussions.microsoft.com (mikaman) — Fri, 18 Dec 2009 23:23:01 UT

What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?

Line Chart Query

fur...@discussions.microsoft.com (Furn16) — Fri, 18 Dec 2009 22:59:02 UT

Hi,
I am trying to put together a line chart of some information. The problem is
that it looks quite crowded on the chart. Is there a way of having a line
chart where you can select a few of the data sources to see just those lines,
without having to have a different chart for each data source?
My ideal situation would be where I have 18 data sources, and I can click

month count

da...@discussions.microsoft.com (David) — Fri, 18 Dec 2009 19:00:01 UT

How to set a formula to count the number of month between two dates?
example:
Jan 5,2009 to Feb 4, 2009 = 1 month
Feb 5, 2009 to Apr 6, 2009 = 3 month (round up)

Re: Displaying content of a cell somewhere on the chart

blien...@stfx.truenorth.ca (Bernard Liengme) — Fri, 18 Dec 2009 14:37:13 UT

You can link a chart title (axis or main) to a cell by
selecting the title, typing = in the formula bar and clicking the cell to
generate a reference such as =Sheet1!$A$1
best wishes

Costa Rica’s Real Estate

costaricaviews2...@gmail.com (Bret G Dudl) — Fri, 18 Dec 2009 09:48:55 UT

I am running the blog [link].
I have put there Costa Rica’s Real Estate Development Climate. I put
here for
your information.
Currently, in the Central and South Pacific regions of Costa Rica,
private development has funded three marinas and a dozen major coastal
developments worth nearly $2 Billion. Marina Pez Vela in Quepos will

charts toolbar / charts disappeared

p...@discussions.microsoft.com (Pro) — Fri, 18 Dec 2009 01:31:02 UT

am working in 2007 version of excel. After an accidental keystroke (possibly)
charts in both my active worksheet and in inactive worksheets in the active
workbook DISAPPEARED! Furthermore, from the INSERT tab, the Chart toolbox is
dimmed and I can't activate. Closing and reopenind spreadsheet did not help.

How can I create a 3-D scatter plot with 3 axis (X, Y, and Z)

s...@discussions.microsoft.com (SML) — Fri, 18 Dec 2009 01:29:01 UT

make column headings automatically appear as axis chart labels

polydatascat...@discussions.microsoft.com (polydatascatter) — Thu, 17 Dec 2009 23:39:02 UT

if i highlight a range (say two columns ) of data and i have the first col as
'x' values with the data type as a column heading eg 'length (metres)' and
the 2nd column as say 'weight (kilograms)', can I get Excel to automatically
use these upper cells as axis labels when i insert a chart?

vba to hide two grouped charts in 2003 - doesn't work

hcg...@hotmail.com (Harold Good) — Thu, 17 Dec 2009 21:03:23 UT

Hi,
I have the following code which works fine in 2007. But since I have
some users that still use 2003, when I save the spreadsheet in 2003 xls
format, this code will no longer work. I found that when I ungroup the
two charts, then it works fine.
Do I need to use code to Ungroup them first, or is there a simple solution?

How To Chart A Formula in Excel 2007

kriswrigh...@discussions.microsoft.com (Kris_Wright_77) — Thu, 17 Dec 2009 16:01:01 UT

I'm looking to plot multiple formulas on a single chart, and came across a
thread from 8/12/2005 for earlier versions of Excel for a single function,
which causes errors when recreated in 2007.
Error is
A Formula in this worksheet contains one or more invalid references
Verify that your formulas contain a valid path, workbook, range name, and

Standard Chart from PivotTable ?

enterp...@web.de (H.G. Lamy) — Thu, 17 Dec 2009 10:38:05 UT

Hello,
(how) can I create a normal chart based on a PivotTable ?
Thank you in advance.
H.G.Lamy

Charting with empty columns in between

a...@discussions.microsoft.com (ARD) — Thu, 17 Dec 2009 10:21:01 UT

Let's say the data is
Particulars Frequency
q 5
w -
e 6
r 7
While drawing a chart, it should not show wth column when it is 0, otherwise
it should take it into consideration. How ?

How do I make a graph with 2-cycle X 3-cycle log-log graph paper?

charlesa.wil...@discussions.microsoft.com (Charles A. Wilson) — Wed, 16 Dec 2009 23:54:01 UT

I need to create a graph that uses 2-cycle by 3-cycle log-log graph paper. I
was told that Excel can be used to do this. However, after fiddling around
with it for an hour, I have been unable to figure out how to do it. Any
suggestions?

Urgent Help - Plot Quartiles as vertical lines in Chart

trading.a...@gmail.com (TAlgo) — Wed, 16 Dec 2009 16:39:51 UT

All,
Sorry but need some quick help in this project. I was told to create a
quartile chart for last one year of closing price of Soybean
Commodity. I am going to paste small data set here. Can someone please
guide how to show quartiles as vertical lines in a chart?
Also someone please suggest what should be X axis and Y axis values

rename category names

renamecategoryna...@discussions.microsoft.com (rename category names) — Wed, 16 Dec 2009 07:30:01 UT

I have the data in the below format
vendor amount
a 100
b 200
c 300
d 400
Now in the chart i want the category names as a,b,other(c,d should appear as
other). Total amount of c and d should show up for other. Can you please
suggest how this is possible.

text to columns

da...@discussions.microsoft.com (David) — Tue, 15 Dec 2009 22:42:01 UT

i am trying to text the data into two columns (delimited by space) but can
only display the names in a new column line but not the rest number. The data
are all in one cell but with a square box after the name. I guess it is the
Return key symbol. How I can remove it or text the data into two. I need to

Excel 2007

d...@discussions.microsoft.com (Dale) — Tue, 15 Dec 2009 16:06:02 UT

Having problems dragging text from one cell to another without moving outside
boaders lines?

VBA Axis line weight

steve31...@gmail.com (SteveG) — Tue, 15 Dec 2009 16:00:51 UT

I am trying to set a number of parameters on a chart but am missing a
way to set the axis line thickness (weight)? I have XLS 2007.
With ActiveChart.Axes(xlValue, xlPrimary)
.AxisTitle.Font.Name = "Arial"
.AxisTitle.Font.Size = 12
.AxisTitle.Font.Bold = True
.AxisTitle.Font.ColorIndex = 16

Chart Data Source

tr...@discussions.microsoft.com (Trev B) — Mon, 14 Dec 2009 12:23:01 UT

Hi,
Thanks in advance.
How do I get the data source of a chart and put it in a varable with VBA code?
Thanks
Trev B

wholesale Lakers #24 BRYANT blue nba jersey, replica Los Angeles Lakers Jersey

yuyongwen2...@gmail.com (泳雯余) — Mon, 14 Dec 2009 05:57:22 UT

wholesale Lakers #24 BRYANT blue nba jersey, replica Los Angeles
Lakers Jersey
Click Here To Website : [link]
wholesale Los Angeles Lakers Jersey
Lakers #24 BRYANT blue nba jersey Information :
[Name]: Replica Los Angeles Lakers Jersey jersey

Copy chart with associated table

a...@discussions.microsoft.com (Arun) — Sun, 13 Dec 2009 01:24:01 UT

I have a table with a chart alongside that is neatly tied to it.
I now want to duplicate this chart / table pair multiple times on the same
sheet so I can change the table data and get unique charts. I select all the
rows that contain the table / chart pairing then copy and paste them down
below. I now have a new "table 2" and a new "chart 2"- however the new

Using drop down lists

matthew.heartlan...@discussions.microsoft.com (matthew. heartlandFM) — Fri, 11 Dec 2009 19:09:02 UT

I'm trying to create a report utilizing a drop down list in Excel. I have
successfully created the drop down list, (I'm using every Monday in January
as my different items on my list) but now I want to enter different data
using the same rows and columns for each specific date. This is just a

Poor quality of Excel chart in PowerPoint

garymcg...@discussions.microsoft.com (Gary McGill) — Fri, 11 Dec 2009 11:26:01 UT

[Office 2003]
I have a long-standing problem that's driven me crazy for years. This is a
cry for help from a desperate man!
The problem I have, briefly, is that when I embed an Excel chart in a
PowerPoint presentation, it looks really bad because the text (e.g. category
labels) is rendered very poorly. Even when I use a standard font like Arial,

Can I use 'names' in defining a series in a graph

dba...@discussions.microsoft.com (dbasmb) — Fri, 11 Dec 2009 00:06:02 UT

I have successfully used the name feature to name individual cells and ranges
of cells and than have used them in formulas. However, when I try to use a
name in the definition of a series on a graph, it says there is an invalid
reference. Am I doing something wrong, or can you not use names in series

Chart worksheet names keep resetting

dloo...@discussions.microsoft.com (dloomer) — Thu, 10 Dec 2009 17:58:01 UT

Hello,
I have been working with 3.5 - 6.5 Mb excel 2007 files that contain one
worksheet of data and up to 20 individual chart worksheets. I have each sheet
named for reference, but every so often when I open a document, I find all of
the chart worksheet names have been reset to Chart 1, Chart 2 etc. and there

Graph Text Relationships with Relative Time X?

d...@discussions.microsoft.com (drew) — Thu, 10 Dec 2009 17:14:01 UT

i want to create a depiction of data sources based on latency and durability,
but these are not numeric.
Durability
Latency Now Week Pay Run Month Qtr Yr Archive Forever
Analytic
DW---------------------------- --------------------

Problem with line Chart

formulah...@discussions.microsoft.com (Formula help) — Thu, 10 Dec 2009 15:49:02 UT

I have the following data:
Date Value
1/07 700
3/07 550
9/07 600
10/07 550
7/08 500
9/08 700
2/09 750
8/09 600
I would like to create a simple line chart connecting the Value points. Note

Where can I get a free gauge chart for excel?

metrics...@discussions.microsoft.com (Metricsguy) — Thu, 10 Dec 2009 15:41:02 UT

I have seen numerous pay sites with gauge charts available, but need a free
one for work computer.

SeriesCollection(10).Name = "=""""""NBT""""""" What are all these quotes?

catebekens...@yahoo.com (cate) — Thu, 10 Dec 2009 15:26:15 UT

With the goal of some VBA later, I am playing with charts and saw this
in a recording:
ActiveChart.SeriesCollection(1 0).Name = "=""""""NBT"""""""
I was changing the name of a series to a text string of NBT. What is
the reason for all the quotes.?
FYI. Using a range I selected the cell with the name as a text

Plotting a current Date Vertical Line

alberthb...@discussions.microsoft.com (Albert H. Bell) — Thu, 10 Dec 2009 04:35:01 UT

I have 2 sets of data, Both have an x-axis that is a date and time (12/7/2009
3:00 AM) and the y axis is count. The two sets of data are a current data
set, and a perfect world data set. Both of the data sets look in the past
and the future. I want to plot a vertical line that represents the current

Finding second data point on primary axis of two axis chart

alcharbonn...@discussions.microsoft.com (Al Charbonneau) — Wed, 09 Dec 2009 23:12:07 UT

Hi
I am new to Excel 2007 (moved from Excel 2003). I have a chart with one
column on the primary axis and a line on the secondarry axis. I added a
second series of data on the primary axis and can't find it. This usued to
happend with my previous edition of Excel and was quickly remedied by putting

X Y Charts - Different Label for Each Point

d.wilker...@discussions.microsoft.com (D. Wilkerson) — Wed, 09 Dec 2009 17:57:01 UT

I have a similar issue to the one posted in "Why does X axis become another
data series". I want to build an X Y chart with a different label for each
of the rows/points. For example,
Item Distance Height
Red 0 5
Blue 5 4
Green 8 3

Why won't data hide?

mar...@discussions.microsoft.com (Margie) — Wed, 09 Dec 2009 17:45:03 UT

Why does hidden data still appear when a chart is generated from a pivot
table? How can I make a series disappear when I hide the column in the pivot
chart?

multiple charts

kathl...@discussions.microsoft.com (Kathleen) — Wed, 09 Dec 2009 17:27:02 UT

Hi, is it possible to create one chart per line of data? I have file with
hundreds of names and their corresponding data that needs to be mail merged
into a letter with their chart.
Kathleen

Linking excel charts into word and updating them

excelmon...@discussions.microsoft.com (excel monkey) — Wed, 09 Dec 2009 11:24:05 UT

When i link an excel chart in to a word document the y axis label is rotated
from being parallel with the vertical axis to stacked alongside the vertical
axis. This makes the title impossible to read. The chart remains correct in
excel, but once updated in word it rotates. This does not happen if the

Moving locations of major, secondary gridlines

ldun...@discussions.microsoft.com (LDuncan) — Tue, 08 Dec 2009 21:27:01 UT

Is there a way to change the location of major, secondary vertical gridlines?
My data points, associated with the secondary vertical axis, do not fall in
the right position on the chart. Rather than falling in the middle of the
individual categories on the x-axis they are offset randomly to the right or

individual graphs

kathl...@discussions.microsoft.com (Kathleen) — Tue, 08 Dec 2009 20:27:01 UT

Hi, I have a report with 11,000 names/data and need to have a graph for each
name and then mail merge to another document. Is this possible?
Kathleen

Add addional data on top of bar chart data

ro...@discussions.microsoft.com (rosie) — Tue, 08 Dec 2009 20:04:01 UT

How do I add a dotted/shaded stack on top of an existing one.
Ex:
I have 2 stacks that represent revenue shipped in each of 4 Quarters .
Then in the next quarter I have revenue shipped to date.
Now I need to add projected revenue to ship on top of the shipped data in
this 1 Quarter only. The bottom data ( shipped to date ) is a solid color,

change range for multiple charts

yossieven...@discussions.microsoft.com (Yossi evenzur) — Tue, 08 Dec 2009 13:14:01 UT

Hi
I need to change the range for multiple charts, i.e. i have to go chart by
chart and modify, either with the mouse or by typing, the new range, is there
a quicker way to do this?

what is the difference between normal chart and pivot chart

d...@discussions.microsoft.com (DAZ) — Tue, 08 Dec 2009 07:56:01 UT

what is the difference between normal chart and pivot chart

Copy paste error

Tue, 08 Dec 2009 06:57:47 UT

paste option is disable when ever I paste excel document to a newly opened word file. How can i solve this issue
Submitted via EggHeadCafe - Software Developer Portal of Choice
Compressed Ink for Tablet PC and Windows XP
[link]

Data in secondary axis dizappears when using names

d...@discussions.microsoft.com (Dom) — Tue, 08 Dec 2009 04:42:01 UT

Hi there, I'm using Excel 2007 and the problem I'm facing is this: I've
created a graph which reads data frrom a simple table. Then I named the rows
in that table using the OFFSET formula as I want to plot only the last 10
entries of the table and not the whole table. The names that I've given are,

change color of curve line as time changes

cliffor...@discussions.microsoft.com (cliffordjf) — Tue, 08 Dec 2009 00:00:02 UT

I have a series of values associated with dates; the values in the past are
fact, the values in the future are estimates. When I graph the data, the
line is all the same color throughout the series. Is there a way to have the
color of the line change as the dates become past, rather than future....

How do I add category labels in a chart but keep series separate?

l...@discussions.microsoft.com (Lulu) — Mon, 07 Dec 2009 19:54:01 UT

I'm trying to add axis labels to a bar chart but can't seem to do it unless I
link my series together. If I do this then I can't put separate error bars
on each bar. This is driving me crazy and any help would be great. Thanks!!!

how do you Combin Percentages (ie 0 to 2 %) in a pie a chart 2007

p...@discussions.microsoft.com (paz) — Mon, 07 Dec 2009 14:15:01 UT

how do you Combin Percentages (ie 0 to 2 %) in a pie a chart for 2007

Circumvent "Series formula is too long"

mor...@discussions.microsoft.com (Morten) — Mon, 07 Dec 2009 13:51:01 UT

Hi,
I have a weekly weekly data set that is the basis for a trend graph for one
year. This works ok until about the 16th week, then I get "Series formula is
too long".
It seems the use of named range is the only way around this...?
I have tried this, looked through previous posts and replies here, but this

standard deviation

c...@discussions.microsoft.com (Clem) — Sun, 06 Dec 2009 15:16:01 UT

I am making a simple bar graph with two data sets that I want to compare. I
want to have the error bars represent the SD rather than % or something else.
All I can get it to do is put the same bars on both data sets, which is not
correct. I have calculate the SD and know that it is not the same for both

Make a bell curve chart

jack...@discussions.microsoft.com (jackeen) — Sat, 05 Dec 2009 16:37:01 UT

i have a spreadsheet with results of a 5k race, 950 finishers.
i am trying to make a bell curve chart that shows the rate at which
finishers come in;
i changed the time to a decimal by using the formula "=(C2-INT(C2))*24"
that helped, and i now have a valid line chart
i trying to show that the majority of finishers are between 8 - 11 minutes,

Interval in legends in surface charts

l...@flexcom.dk (Lars Thomsen Nielsen) — Fri, 04 Dec 2009 22:16:59 UT

Excel2007. Is it not possible to change the intervals in the legends in
a surface chart in Excel2007? In Excel2003 I could doubleclick on the
legends and hereby change the scale, but I can't figure out how to do it
in Excel2007.
I have uploaded a picture, so you can see my graph with the legends on

Shorten chart formula

b...@discussions.microsoft.com (B141) — Fri, 04 Dec 2009 19:33:01 UT

Office 2003 version:
I'm having trouble with learning/applying correct syntax. Please help me
shorten the series for a stacked column chart. Example:
=SERIES("DX
only",(Nov!$E$69,Nov!$I$59,Nov !$N$59,Nov!$H$59,Nov!$O$59,Nov !$S$59,Nov!$Z$59,Nov!$E$80,Nov !$I$59,Nov!$N$59,Nov!$H$59,Nov !$O$59,Nov!$S$59,Nov!$Z$59,Nov !$E$91,Nov!$I$59,Nov!$N$59,Nov !$H$59,Nov!$O$59,Nov!$S$59,Nov !$Z$59,Nov!$E$102,Nov!$I$59,No v!$N$59,Nov!$H$59,Nov!$O$59,No v!$S$59,Nov!$Z$59,Nov!$E$113), (Nov!$E$70,Nov!$I$70,Nov!$N$70 ,Nov!$H$70,Nov!$O$70,Nov!$S$70 ,Nov!$Z$70,Nov!$E$81,Nov!$I$81 ,Nov!$N$81,Nov!$H$81,Nov!$O$81 ,Nov!$S$81,Nov!$Z$81,Nov!$E$92 ,Nov!$I$92,Nov!$N$92,Nov!$H$92 ,Nov!$O$92,Nov!$S$92,Nov!$Z$92 ,Nov!$E$103,Nov!$I$103,Nov!$N$ 103,Nov!$H$103,Nov!$O$103,Nov! $S$103,Nov!$Z$103,Nov!$E$114), 1)

setting default filter setting

tpe...@discussions.microsoft.com (tpeter) — Fri, 04 Dec 2009 14:50:01 UT

I am working in Excel 2003 and have set up a pivot chart with two series of
data in the data area. When I only use one of them the default it sum I can
change it to average or whatever I want. When the second series is added the
first is still average but the second defaults to sum and I can't change it.

Why does X axis become another data series?

philipreeceh...@gofast.co.uk (Philip Reece-Heal) — Fri, 04 Dec 2009 11:13:41 UT

Take the following data to use with Chart Wizard to get a chart:
Distance height
0 5
5 4
8 3
9 6
12 7
13 8
If I highlight all data including column titles, the chart wizard produces
both columns as Series, whereas I want Distance column to be X axis values.

How can I reset the default pie chart label "Other" to "Equity"?

r...@discussions.microsoft.com (russ) — Thu, 03 Dec 2009 17:36:01 UT

I show Cash, Equities, and Fixed Income in the large pie to the left. The
equity slice is further split into large, medium, and small. The problem is
that the Equity slice gets relabeled as "Other". When I manuallly change it
back to Equity, I lose the ability to link to any new data...so I can't use

Appending Pairs of Column Data!

mas_it_2...@yahoo.com (Mike) — Thu, 03 Dec 2009 14:58:01 UT

Hi Everyone,
Say I have pairs of columns as follows:
A B C D E F
Mrr1 acf2 Mrr1 WPP1 acf1 WPP1
Mrr1 WPP2 acf2 WPP1
acf3 WPP1
acf1 WPP2
acf2 WPP2
acf3 WPP2
Contents are dynamic in length, and I want in a separate sheet to
create single pair of columns where contents of all contents above are

Delete Name Box!

mas_it_2...@yahoo.com (Mike) — Thu, 03 Dec 2009 14:47:23 UT

I know how to create a Name Box for a range, but how do you delete
it?! It is like I forgot it is done!

"Dynamic" Legends

e...@discussions.microsoft.com (E. Q.) — Thu, 03 Dec 2009 06:05:01 UT

I have a chart that has a series that simply illustrates the geometric mean
(as a flat line) spanning the seven days of a given month with the highest
7-day moving geometric mean. (So if the max 7-day geomean were on day 7, the
series has the value of that geomean showing from day 1 through day 7... when

Line and Bar on same chart

djb...@dcwis.com (Dave) — Wed, 02 Dec 2009 21:04:15 UT

Any way to plot line data and bar data on the same chart?
For example, chart showing fuel tank cumulative gallons plus showing individual fills as bars, both vs. date
Date Fill Cumulative
Jan 100 100
Mar 250 350
Jun 175 525
Thx
Dave
Office(Excel) 2003
I'll try this in HTML

How to combine two reports in one chart

byron...@discussions.microsoft.com (Byron720) — Wed, 02 Dec 2009 20:38:01 UT

I'm working on a shipping report that includes 3 different shipping regions.
I created new reports for each region and now I want them to be in one common
chart. How do I do that?

can i edit only a selected range of data in an excel chart?

aa...@discussions.microsoft.com (aarho) — Wed, 02 Dec 2009 20:03:01 UT

I perform a lot of tests that involve changing changing an element during the
run and observing the effects over time and it would be extremely useful if I
could create a trendline that covered only the desired range of data, rather
than spanning the entire chart, without having to go in, find the data range

charting time series with milliseconds with scatter

ecoul...@discussions.microsoft.com (ecoulson) — Wed, 02 Dec 2009 18:29:01 UT

I am trying to plot data dumped to csv file with time series so X Axis is the
time in following format (currently): Dec-1-2009 09:48:39.972 AM
I can change this format if it helps. The times are sample times of data
and are not uniform in interval. So chart needs to respect the the different
XAxis intervals between ticks. I update the data from csv file it looks

Multi-Level Category Labels

ja...@discussions.microsoft.com (Jared) — Wed, 02 Dec 2009 18:24:01 UT

I need help trying to get the check box for Multi-level category labels in an
excel chart. I have it on one chart, saved it as a template, and then
inserted the template into the same spreadsheet. Reslected the new data but
it will not give me back the check box option for Multi-Level Category Labels

Adding data labels to bubble charts

ja...@discussions.microsoft.com (James) — Wed, 02 Dec 2009 16:00:02 UT

Hi all
I have created a bubble chart using the following data:
Region Pax Net T'over PPP
WEU 2,767 2,208,782 507
NEU 726 855,592 296
EEU 733 787,839 315
BKN 743 719,743 299
Problem is if I create the report just using the data then it labels all of
the bubbles as "series 1". When I use all of the data including the column

Show fraction as fraction even if answer is 1

Wed, 02 Dec 2009 15:23:54 UT

I have excel sheet and I am trying to get data from from two diff columns. example C23 has certain value and F23 has certain value. Now after playing around, I found the fraction C23/F23 to show as fractions, but when the answer for C23/F23 comes to 1, then it shows 1. how can I have that show 10/10?

How can I work out percentages of a particular column?

maly...@discussions.microsoft.com (malycom) — Wed, 02 Dec 2009 15:10:02 UT

Hi
I have 1160 rows of client information listing the addresses and country.
The last column is the country and what I would like to do is to show a
graph that calculates how many times a country is listed in the column and
then work out the percentage of it's use.
For example, assuming it was 100 clients and only United Kingdom, USA and