|
More site info...
Charts and Charting in Excel | Forum profile
|
|
Forum profile page for Charts and Charting in Excel on http://excelbanter.com.
This report page is the aggregated overview from a single forum: Charts and Charting in Excel, located on the Message Board at http://excelbanter.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Charts and Charting in Excel" on the Message Board at http://excelbanter.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Charts and Charting in Excel:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
60
|
196
|
656
|
|
Post:
|
126
|
354
|
1,156
|
|
|
Charts and Charting in Excel Posting activity graph:
|
Top authors during last week:
user's latest post:
Solver not working - Page 3 -...
Published (2009-12-09 05:34:00)
On Dec 8, 6:58*pm, Herbert Seidenberg > wrote: > Excel 2007 > Yes, Goal Seek has only one variable, > but a workaround is iteration and RMS. > Illustrated that by adding two more columns. > Graphed it for visualization. > Solution has a range of values. http://c0444202.cdn.cloudfiles.racks...12_07_09a.xlsm Thanks, I'll take a look tomorrow afternoon. In the meantime, Ray Koopman over at...
Kerry[_2_] external usenet poster
12
user's latest post:
Solver not working - Page 2 -...
Published (2009-12-07 20:21:00)
On Dec 8, 1:03*pm, Kerry > wrote: > On Dec 8, 12:36*am, Kerry > wrote: > > > > > On Dec 7, 5:33*pm, "Mike Middleton" > > > wrote: > > > > Kerry *- > > > > > Are there other Solver limitations I need to know about that could be > > > > causing the issue?...
user's latest post:
Poor quality of Excel chart in...
Published (2009-12-11 16:28:00)
This can be problematic. I've found the best results when the chart is exactly the size in Excel it needs to be to fit where you want it in the slide, without any resizing. I usually use Copy-Picture (hold shift while clicking on the Edit menu), then I pick the on screen and picture options. PowerPoint 2003 is pretty good at rendering a bitmap too, even if it is rescaled. - Jon ------- Jon Peltier Peltier Technical Services, Inc....
user's latest post:
SeriesCollection(10).Name =...
Published (2009-12-12 19:57:00)
Excel 2007 Chart VBA with lots of quotes, and alternate variable presentation. http://www.mediafire.com/file/owfzdzmzw23/12_12_09.xlsm
user's latest post:
Interval in legends in surface...
Published (2009-12-07 12:43:00)
> "Chart Tools" is the contextual tab that appears when a chart is selected. > Within the Chart tools tab are the Design, Layout and Format tabs. OK, now I get it and it works :-) Thanks again. Lars
user's latest post:
Plotting a current Date Vertical...
Published (2009-12-10 09:44:00)
Hi, Sounds like you have at least 1 of your cells as text. Try put 1 in a spare cell and then copy it. Select your date range and use PasteSpecial+Multiply to force text to values. Cheers Andy Albert H. Bell wrote: > 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...
user's latest post:
How do i locate the point of...
Published (2009-12-12 22:09:00)
What is the equation of the logarithmic line? Different people use different expression - what do you use? -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "Maria F" wrote in message ... > How can I find the intersection between a logarithmic curve and a straight > line? > > Thanks. > > > > Bernard Liengme wrote: > > I will assume you...
Lars Thomsen Nielsen external...
3
user's latest post:
Interval in legends in surface...
Published (2009-12-07 12:43:00)
> "Chart Tools" is the contextual tab that appears when a chart is selected. > Within the Chart tools tab are the Design, Layout and Format tabs. OK, now I get it and it works :-) Thanks again. Lars
Herbert Seidenberg external...
3
user's latest post:
Solver not working - Page 3 -...
Published (2009-12-08 00:58:00)
Excel 2007 Yes, Goal Seek has only one variable, but a workaround is iteration and RMS. Illustrated that by adding two more columns. Graphed it for visualization. Solution has a range of values. http://c0444202.cdn.cloudfiles.racks...12_07_09a.xlsm
Morten external usenet poster
2
user's latest post:
Circumvent "Series formula...
Published (2009-12-07 17:41:00)
Hi, The data is allready rearranged to the maximum possible, and that's was no 5 minute job! What I have found is the problem is when two named ranges are used (it works with just one). Named range one contains week 32-42 - let's call it "w32_42". Named range two contains week 43-53 - let's call it "w43_53". When this is entered in graph's range:...
|
|
|
|
Latest active threads on Charts and Charting in Excel::
Started 1 week ago (2009-12-08 07:57:00)
by ganeson r
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
http://www.eggheadcafe.com/tutorials...or-tablet.a spx
Started 3 days, 2 hours ago (2009-12-13 02:24:00)
by Arun external usenet poster
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
"chart 2" is still tied...
Started 3 days, 7 hours ago (2009-12-12 22:09:00)
by Bernard Liengme
What is the equation of the logarithmic line? Different people use different
expression - what do you use?
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
"Maria F" wrote in message ...
> How can I find the intersection between a logarithmic curve and a straight
> line?
>
> Thanks.
>
>
>
> Bernard Liengme wrote:
>
> I will assume you have two ...
Started 3 days, 9 hours ago (2009-12-12 19:57:00)
by Herbert Seidenberg
Excel 2007
Chart VBA with lots of quotes,
and alternate variable presentation.
http://www.mediafire.com/file/owfzdzmzw23/12_12_09 .xlsm
Started 4 days, 12 hours ago (2009-12-11 16:28:00)
by Jon Peltier[_2_]
This can be problematic. I've found the best results when the chart is
exactly the size in Excel it needs to be to fit where you want it in the
slide, without any resizing.
I usually use Copy-Picture (hold shift while clicking on the Edit menu),
then I pick the on screen and picture options. PowerPoint 2003 is pretty
good at rendering a bitmap too, even if it is rescaled.
- Jon
...
Started 5 days ago (2009-12-11 04:42:00)
by Jon Peltier[_2_]
There are innumerable examples on the internet showing how to use names
as your chart source data. See for example:
http://peltiertech.com/WordPress/dynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html
What is probably leading to your error is using just the name, without
referencing its parent worksheet or workbook. For example, the name
ChartData will produce an ...
Started 5 days, 9 hours ago (2009-12-10 20:06:00)
by Herbert Seidenberg
Excel 2007
Various approaches with
PivotTable, PivotChart, Step Chart
http://c0444202.cdn.cloudfiles.racks...12_10_09a.x lsx
Started 6 days, 9 hours ago (2009-12-09 19:24:00)
by David Biddulph[_2_]
If you don't want to format each point separately, your best bet is to put
each point in as a separate series. I don't think that the wizard will do
this easily for you, so you'll need to add them a series at a time.
--
David Biddulph
"D. Wilkerson" <D.
|
|
Hot threads for last week on Charts and Charting in Excel::
Started 2 weeks ago (2009-12-02 03:24:00)
by Bernard Liengme
You cannot have conditional functions within a Solver model
So the problem seems to be the IF statements
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
"Kerry" > wrote in message
...
> I have 4 cells that Solver is supposed to change to minimize the value
> of one target cell, where the target cell sums a bunch of rows that
> have changed ...
Started 1 week, 4 days ago (2009-12-04 23:46:00)
by Jon Peltier[_2_]
Double clicking is broken in 2007 charts. Such a fundamental behavior.
Right click on the axis, choose the Format item in the pop up menu, and
see what that gets you.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Lars Thomsen Nielsen wrote:
> Excel2007. Is it not possible to change the intervals in the legends in
> a surface chart in...
Started 5 days, 23 hours ago (2009-12-10 05:35:00)
by Albert H. Bell external usenet poster
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
Date and Time (I am using =now() to create that line. The vertical line
works and ...
Started 1 week, 1 day ago (2009-12-07 16:34:00)
by Dnyaneshwar Gaikwad external usenet poster
" Yossi evenzur" wrote:
> 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?
Started 1 week, 1 day ago (2009-12-07 14:51:00)
by Morten external usenet poster
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
does not work for me. It seems only applicable to very simple data sets and...
Started 6 days, 10 hours ago (2009-12-09 18:57:00)
by Andy Pope
Hi,
If you hide the column manually it will still be displayed in the chart.
Because the chart is liked to the pivot table.
If you hide the column via the field filter the information should
disappear from the chart.
Cheers
Andy
Margie wrote:
> 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 ...
Started 6 days, 9 hours ago (2009-12-09 19:24:00)
by David Biddulph[_2_]
If you don't want to format each point separately, your best bet is to put
each point in as a separate series. I don't think that the wizard will do
this easily for you, so you'll need to add them a series at a time.
--
David Biddulph
"D. Wilkerson" <D.
Started 6 days, 5 hours ago (2009-12-10 00:12:00)
by Al Charbonneau[_2_] external usenet poster
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
the cursor on the horizontal line until I found it. Is there another way to
find ...
Started 1 week ago (2009-12-08 07:57:00)
by ganeson r
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
http://www.eggheadcafe.com/tutorials...or-tablet.a spx
Started 1 week, 1 day ago (2009-12-08 01:00:00)
by cliffordjf
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....
in other words, the line is black through todays data, but turns to red from
...
|
|
Size: 528 bytes
