|
Extra Lines Inserted in Multi-Line Chart Titles
Has anyone else encountered the following problem?
Very frequently, when I create a chart in Excel 2007, give the chart a
2-or-3-line title, save worksheet in the Excel 97-2003 file format, and then
re-open the file in Excel 2007, I will find that Excel has inserted two extra
linefeed characters (ASCII character 10) between each line and often
truncates the last character or last few c...
|
2 |
12/23/2008 5:56:00 AM |
|
|
SeriesCollection question
Very simple question....
Is there a way to get the max number of the SeriesCollection? The
reason I am asking is that I use a date range to properly configure
my chart Based off the dates, I may have different amount if
seriescollections....
|
3 |
12/22/2008 2:29:00 PM |
|
|
Maintain Aspect Ratio of 2D Plot on Different Monitors ??
Hello;
There's a good chance that some might have already posted this question
(including myself!), but I couldn't find any related threads in this forum
directly addressing the problem.
Suppose you've a 2D chart displaying the fuselage of an airplane nicely
proportional on the Full Screen of your desktop monitor.
You copy the w/b to your laptop (with the same XL 2003) and the display...
|
5 |
12/22/2008 12:12:00 AM |
|
|
merge pivot charts?
I have 3 seperate charts created from 3 pivot tables. each table has a filter
office#. user has to go to each table to select office# to get the charts
update. Is there any way to merge 3 tables together, that way user can select
only one time and get the different info for each table?
pivot_table_1
office#
answers
pivot_table_2
office#
answers
pivot_table_3
office#
an...
|
2 |
12/21/2008 6:06:34 PM |
|
|
How I can switch row/column in pivot chart?
Hi,
I have the new office 2007, in excel I try to draw pivot chart, I succeded.
But I want to switch row into column and column into row. When I try to do
that tis button bocomes invisible while I can do in PPT.
Please help me!!
Regards,
Tuba Kesen Umar
...
|
2 |
12/20/2008 3:06:37 PM |
|
|
Line Chart
I have created a line chart that has data that goes from 82-104. It is over
a 3 year period so I have 3 lines on the chart. I need to put a horizontal
line across the chart at 94 to show a baseline and when the lines have dipped
below this value. Is there a way to add this line. I am using Excel 07.
Thanks in advance....
|
4 |
12/20/2008 3:00:10 PM |
|
|
Gnatt Chart
I have the following data. (Duration2 = Duration x 0.000694) (0.000694 =
decimal equivalent of 1 minute)
A1 B1 End Duration Duration2
Activity 1 5:30 AM 6:15 AM 45 0.03123
Activity 2 6:15 AM 6:45 AM 30 0.02082
Activity 3 6:45 AM 6:50 AM 5 0.00347
Activity 4 6:50 AM 7:04 AM 9 0.006246
Activity 5 6:59 AM 7:04 AM 5 0.00347
Activity 6 7:04 AM 7:19 AM 15 0.01041
Activity 7 7:19 AM 7:44 AM...
|
8 |
12/20/2008 2:59:18 PM |
|
|
Locking Chart Area
Hi,
If i insert a chart sheet into an excel workbook I get a Chart sheet and on
top of it is a Chart Area that can be moved and resized. My Question is how
do I lock the Chart Area from being moved or resized? I've tried setting the
locked property on the Chart Area, Protecting the workbook, through the
interface and through VBA with no luck. What am i missing here?
Thanks,...
|
5 |
12/20/2008 2:00:00 PM |
|
|
C#: XYScatter chart with smooth lines and no markers
I hv been working on a Office 2007 App level add-in project using VS2005,
..Net 2.0, VSTO for Office 2007 and Office 2007 Interopps. I want to draw a
XYScatter chart with smooth lines nad no markers.
Why, even if we set the ChartType to xlXYScatterSmoothNoMarkers you get
markers?
xlChart.ChartType =
Microsoft.Office.Interop.Excel.XlChartType.xlXYScatterSmoothNoMarkers;
Is there...
|
2 |
12/19/2008 1:38:01 AM |
|
|
Can I save format changes to a Pivot Chart?
Once a Pivot Chart has been created in Excel I can edit the format of the
chart (such as changing colors, lines to bars, chart type, etc.). Once I
pivot to new information, however, the formatting is lost and the chart
returns to its original format. Is there a way I can save the format so that
the chart keeps the formatting even when I pivot the data?...
|
5 |
12/18/2008 9:00:01 PM |
|
|
trend lines on plots with negative X values
When I scatter plot a set of data with negative x values and add a trend
line, the trend line extends to x=0, when I would expect it to just cover the
data range.
eg
-2.3 1
-2.4 0
-2.7 -1
-3 -4
This is without the extending the trendline using the forecast options.
if I plot positve x values the bug does not happen
eg
2.3 -4
2.4 -1
2.7 -2
3 3
I am using Excel 2007 (12....
|
2 |
12/18/2008 6:26:25 PM |
|
|
Size with Window
I'm working on a workbook with several charts. When I "create a copy" of a
worksheet that contains only a chart, the copy comes in automatically set to
"size with window". I don't want this to happen and can't figure out how to
undo the feature. I tried clicking on the icon, using Alt+, etc. to no
avail. Any suggestions?
Telecommuting using Excel 2003 from work.
Thanks!...
|
4 |
12/18/2008 1:31:12 PM |
|
|
Multiple day reporting
I want build a report that shows Daily Graphs for a month with 48 values for
each day. The graphs would be individual where Mondays are always above
Mondays, Tuesday above Tuesdays arranged in a matrix that allows easy
comparison of data used in each day. ie: there would be 7 graphs accross the
page and 4/5 down to cover long months. The report would be used for
different months where I ...
|
2 |
12/17/2008 9:32:39 PM |
|
|
change the text in the legend of a chart w/o changing pivot text
I am trying to create a series of pie charts that compares demographic data
for clients assisted with multiple housing-related activities (new homebuyer,
rehab, foreclosure prevention, etc.) If I want to look at the age of new
homebuyers, on my pivot table I deselect all activities except new homebuyer.
After I make my pie chart, in the legend the labels are "new homebuyer
18-24", "new...
|
3 |
12/17/2008 8:53:51 PM |
|
|
Stacked bar chart with totals - Excel 2003
Hi everyone,
I have a stacked bar chart with 8 items associated with the stacked
chart. What I want is, is there a way to get the total amount for each
stack and display it at the top of each bar? Like a regular bar chart
does.
This would be awesome if someone has some sample code or a add-in!
Thanks!...
|
2 |
12/17/2008 7:24:20 PM |
|
|
How do I insert the file name into a chart (without typing it)?
--
Excel Junkie always looking for formula ideas to more easily crunch data ...
|
3 |
12/17/2008 4:29:12 PM |
|
|
Excel 2007 chart gridline color using vba
Hello,
i want to apply a themecolor to a chart gridline using vba. I can
apply normal colors (RGB, index) but not the theme color. Any idea?
thx.
berg...
|
3 |
12/17/2008 3:32:28 PM |
|
|
Excel 2007 Chart Layout and Styles
Is it possible to modify the given chart layouts and styles in excel
2007 or to create new ones?
thank you....
|
1 |
12/17/2008 3:31:47 PM |
|
|
Charting dates
I am creating a graph in Excel 2007 where there are multiple dates on the X
axis. By default Excel groups duplicte dates togeather on the axis. You can
have them seperate as individual data points by formating the axis and
selecting "Text Axis" in Axis options.
Is there a way to this in Excel 2003?
Terry
...
|
3 |
12/17/2008 3:06:09 PM |
|
|
Worksheet/chart tabs changed names!
I making a workbook that will have approx. 130 charts and name each tab as I
go. Yesterday, I finished up number 68 and this morn I opened the workbook
and found that ALL the tabs have converted to numerals! What would cause
that? I depended on the tab names to inform me of alignment of data. ...
|
10 |
12/17/2008 2:32:42 PM |
|
|
Chart templates treates value axis as a category axis
I saved a Chart Template [Line Plot Type] that uses a horizontal value axis,
but when I try to use it in a new workbook, the data is plotted with a
horizontal category axis?...
|
4 |
12/17/2008 3:19:40 AM |
|
|
How do I change the order of the line versus the marker for a scat
I have a scatter plot with thousands of points (markers only, no line), and
am plotting a second series as a line with only a few hundred points over the
same range of x-values (line only, no markers). I want the line to appear in
front, but Excel 2007 keeps putting the marker symbols in front, which
completely obscures the line.
I have tried changing the series order, but it makes no ...
|
5 |
12/16/2008 6:17:02 PM |
|
|
two line bar graph
i have a two line bar graph. one of the graphs is just a straight line that
shows .1 below the avg, so it changes as diff data is entered. i need the
label to move with the line as the line moves up or down. the way i have it
now is by just using the text box which doesnt move as the line moves. is
there some way to tie the label in with the line movement?...
|
2 |
12/16/2008 4:53:27 PM |
|
|
Edit legend entry for a trendline
Is there a way to edit the legend text for a trendline?
Or is the only option to:
1. delete the tendline legend entry
2. create a "dummy" data series to add the legend item
3. remove the marker and line from the "dummy" series, so only the title
remains....
|
7 |
12/16/2008 4:52:02 PM |
|
|
Dual axis on PivotChart
I created a pivot table that contains data in the following format:
Year | Month | Data 1
Data 2
Year | Month | Data 1
Data 2
etc.
Now, I am trying to create a chart where Data1 and Data2 would be on 2
different y axis (Data1 is an average dollar amount and Data2 is the
number of deals, so they don't work well on the same Y-Axis).
Is there a w...
|
7 |
12/16/2008 4:27:00 PM |