dynamic charts
Tue, 26 Aug 2008 16:39:33 -0700 (PDT)
Hello,
I am trying to make a dynamic chart which would only plot a specified
range. I found a great example (please take a look for the specifics)
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246
My only difference is that my date range goes across and not down. I
am having a difficult t ...
|
How do I refresh pivot table/charts with new data?
Tue, 26 Aug 2008 13:44:00 -0700
I am working in Excel 2007 and when I update my source data, charts in other
sheets do not get updated. ...
|
OTHER options for chart not plotting null ("") or zero values
Tue, 26 Aug 2008 13:21:02 -0700
I've read the above suggestions for a chart not plotting zeros or null
values. This worked....however, then I got errors because of other
calculations (averages) that use these cells as references (and #NA just
doesn't go over well when it's being used in another formula).
Because of the many other formulas ...
|
Charting information from nultiple work books
Tue, 26 Aug 2008 12:58:00 -0700
I have 4 different workbooks of information, with 12 (1 per month) tabs in
each workbook. On each tab I have about 40 lines of information that need to
be graphed. I am having great difficulty doing this. I am relatively new to
excel, so it's a little over whelming. Each tab has 11 expenses, 7 income
rev ...
|
Charting a .csv file in excel 2003
Tue, 26 Aug 2008 12:33:00 -0700
I am trying to chart two columns from a .csv file. In the Chart Wizard.
When it gets to the Data Range, the field is blank. So I high lite the two
columns again, and try to hit next button. Microsoft excel says, "A formula
in this worksheet contains one or more invalid references. Verify that
formulas co ...
|
Re: Play with lines in one chart
Tue, 26 Aug 2008 11:05:05 -0700
Jon,
I am doing the same thing as the post you replied to, I have gone to you
site listed below and it works great! I want to take it to the next level,
is there a way to do it on the chart itself? I like having a chart on its
own tab and have the series selector in the same location.
Albie
"Jon P ...
|
i WOULD LIKE TO FREEZE OLD DATA ON GRAPH TO ALLOW FOR UPDATE VIA M
Tue, 26 Aug 2008 08:02:10 -0700
I have a excel spreadsheet which upon me running the macro updates my graphs
unfortunely due to limitations of 65,000 the system is no longer updating. I
though if I could freeze the data on the graph I could omit the old data and
just update based on the new. Any suggestions.. ...
|
|
|
outliers in charts
Tue, 26 Aug 2008 07:21:00 -0700
I have created a simple bar chart, but I have a few outliers that skew the
layout of the chart.
for example:
a = 2
b = 3
c = 78
d = 2
e = 1
f = 3
g = 150 etc
I still need to include "c" and "g", but because I have a lot of data it
makes the rest of the bars so low you can't tell accurately what the ...
|
chart with norm-range and value
Tue, 26 Aug 2008 13:10:50 +0200
Dear excel-professionals!
How to I get a chart that looks simlar to the following (here shown with
characters)
Skala1 __________--X-------__________
Skala2 __________-------X--__________
Skala3 ________X_-----------__________
etc.
That means
1) the possible range of values is 1 to 100
2) each line has a ...
|
//excel chart as object to excel chart .
Tue, 26 Aug 2008 03:48:01 -0700
Hi . I have an excel chartobject. When i double click i can edit the chart
and the datasheet also appears where i can enter the data in that small
window.
1.) How can i convert it back to the Excel Chart. ?
2.) How do i change the source data ?
3.) How can i add / delete the Legends ?
AND, how do you assig ...
|
