Why do series names on charts disappear when re-opening excel?
Wed, 8 Oct 2008 07:40:34 -0700
I have set up some bar charts in excel to display the series names and values
of each series. However, when I close the application and re-open it, the
series names are gone. I have checked the chart options, and the series name
box is still checked. How do I fix this? Thanks ...
|
Grouping data query
Wed, 08 Oct 2008 09:44:57 +0200
Hi,
I've got grouped sql sitting in an excel sheet as follows:
Cat Supplier Amount
A A 1
A B 12
A D 7
B B 23
B C 9
B E 30
I'm trying to create grouped bars on Category, with bars in the groups
representing ...
|
Excel 2007; graph the best fit line from a regression analysis?
Tue, 7 Oct 2008 14:30:10 -0700
...
|
How to filter field button items in pivot tables
Tue, 7 Oct 2008 13:50:08 -0700
I am making a spreadsheet that displays test times for various software tests
across several sw builds. It looks like this:
Build A runs tests 1-100
Build B runs tests 101-200
Build C runs tests 201-300
Build D runs tests 301-400
All of the data is in my data worksheet.
I build the pivot, then go to the fil ...
|
Scrollbar in charts
Tue, 7 Oct 2008 13:30:04 -0700
I have not used scrollbar in charts before,
I have seen posting for scroll bar option but still did not get it.
if I have to add scroll bar to the chart then what should i do?
I know the icon from the controlbox tool menu but I dont know how to write
the code to connect scroll bar with chart/data.
any help w ...
|
the 100 dollar question
Tue, 7 Oct 2008 11:03:02 -0700
I have already had 2 mod's answer to this, neither of them were right yet and
I am running out of options on how to accomplish this task.
I want to take a workbook containing around 20 sheets, create a new sheet
within that workbook and hyperlink or something to that effect all of the
underlying sheets to ...
|
Stacked Column Chart - Total that isn't the sum of series
Tue, 7 Oct 2008 08:26:04 -0700
Hello!
I need to create a stacked column chart that totals to a percentage that
isn't the sum of the 2 series which make up the stacked column. For example,
I need to show a person has a 10% error ratio. Within that 10%, i need to
show that 40% were one type of error and 60% was another type of error, but i ...
|
|
|
How to put cell data in chart y-axis?
Tue, 7 Oct 2008 06:36:12 -0700
I am having serious trouble with my excel system! I have 1 column for time,
another for temperature, I need time to be on the y-axis and Temp as a line
on the graph. Damn auto-grapher creates a graph with both time and temp as
lines in the graph. PLZ HELP!!!11
P.S Hurry and answer this i have only today to ...
|
Keep chart centered to the page
Tue, 7 Oct 2008 06:05:02 -0700
I always have to recenter charts after closing a file and reopening. How can
I keep charts centered to the page?
--
Mary B. ...
|
Chart does not render plotted points correctly, data comes from a
Tue, 7 Oct 2008 03:45:01 -0700
We have an Excel 2003 front end workbook that draws data from a SQL 2005
"Cube" into a pivot table with an associated pivot chart.
The values on the line chart, as shown e.g. in data labels, are correct
against the pivot table, however in some cases the plotted points on the
chart are way out on the scale - a ...
|
