|
More site info...
Excel Charting | Forum profile
|
|
Forum profile page for Excel Charting on http://www.excelforum.com.
This report page is the aggregated overview from a single forum: Excel Charting, located on the Message Board at http://www.excelforum.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 "Excel Charting" on the Message Board at http://www.excelforum.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 Excel Charting:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
51
|
150
|
374
|
|
Post:
|
178
|
481
|
1,088
|
|
|
Excel Charting Posting activity graph:
|
Top authors during last week:
user's latest post:
Creating a diagram
Published (2009-12-18 23:31:00)
Hi nicodam I don't quite understand. The two lines don't cross. The values of one line are from 100 to 870 and the other line from 320 to 359. They can't cross. But you could add a trend line to both lines with forecasting for about 50 periods, then the trendlines will cross at some point. see attached
user's latest post:
Problem with dynamic chart
Published (2009-12-18 12:22:00)
The COUNTA formula is returning cells with formula in. What if you use the COUNT formula instead. If not you will need some other way of determining where the real data, and not the formula in waiting, starts and finishes.
user's latest post:
Data Labels only on amounts...
Published (2009-12-18 04:50:00)
Thanks, I understand what you mean by a helper column and will try that.
user's latest post:
Creating a Line graph with...
Published (2009-12-16 10:16:00)
Yes, to me too. I guess there's some kind problem with formating but I can't figure it where...
user's latest post:
Chart Problem - Overlapping...
Published (2009-12-17 03:46:00)
Hi, as often with charts, it's all in the data layout. You need to put each data series in a different column and define the range to include the empty cells. Also, make the X axis a date axis. see attached. cheers
user's latest post:
Charting multi-level data
Published (2009-12-09 19:16:00)
That is exactly what I was trying to do...brilliant. I assume it's not possible to get the Periods onto the Horizontal axis? I've tried everything but does Excel only go to two levels? Thanks - your input is really appreciated.
BRISBANEBOB BRISBANEBOB is...
5
user's latest post:
Charting multi-level data
Published (2009-12-09 19:16:00)
That is exactly what I was trying to do...brilliant. I assume it's not possible to get the Periods onto the Horizontal axis? I've tried everything but does Excel only go to two levels? Thanks - your input is really appreciated.
user's latest post:
Problem with excel graph shaped...
Published (2009-12-13 10:24:00)
Quote: Originally Posted by shg Post a workbook and explain in context. I found a way of solving it using NA. At the moment I have created a new column that inserts #NA in the cell, if the value of the cell on the left is blank, otherwise it copies the value of the cell on the left. This looks like that: Code: A B ---------- 1 1 #N/A 2 2 #N/A 3 3 #N/A 4 4 I am using the following formula to insert NA: =IF(ISBLANK(A4),NA(),A4) (formula for B4)...
user's latest post:
Can't create chart on...
Published (2009-12-18 07:16:00)
Andy, I investigated what you said about the print driver and you were correct. I simply added a network printer on and set it to default, and now charts appear ok. Thanks.
|
|
|
|
Latest active threads on Excel Charting::
Started 1 day, 15 hours ago (2009-12-18 23:31:00)
by teylyn
Hi nicodam
I don't quite understand. The two lines don't cross. The values of one line are from 100 to 870 and the other line from 320 to 359. They can't cross.
But you could add a trend line to both lines with forecasting for about 50 periods, then the trendlines will cross at some point.
see attached
Started 2 days ago (2009-12-18 14:24:00)
by DonkeyOte
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If you need a thread moved asked a Moderator to do this for you - I will move your earlier thread accordingly.
Started 2 days, 6 hours ago (2009-12-18 09:11:00)
by Andy Pope
It's not clear from your post what the actual problem is.
Does the formula return error, wrong information?
Where is the reference to the second file?
Started 2 days, 6 hours ago (2009-12-18 08:59:00)
by JeanRage
Hi,
An initial guess would be for you to check the range of your X axis ...
HTH
Started 5 days, 2 hours ago (2009-12-15 12:45:00)
by Andy Pope
You just need to plot an xy-scatter. The divider lines can either be a additional series, gridlines or the axes.
Best if you lay your data out in 2 columns.
X values in first column
Y values in second
Placing a description over the Y values and including this in your selection will make creating the chart with the data correctly recognised simpler.
Started 4 days, 4 hours ago (2009-12-16 11:09:00)
by Andy Pope
does the pc have any print drivers installed?
Started 2 days, 6 hours ago (2009-12-18 08:25:00)
by teylyn
Hi,
you need to arrange your data in two columns:
column label x - height
column label Y - weight
Then select the data without the labels and create an XY scatter chart.
In a separate column, which could be adjacent/before the X column, enter the names. Then use the XY Chart Labeler add-in to associate the scatter chart data points with the names.
The add-in can be downloaded ...
Started 2 days, 21 hours ago (2009-12-17 17:55:00)
by teylyn
Hi Rob,
like this maybe? see attached.
It's not the cleanest and with a little more time and study of this http://peltiertech.com/WordPress/clu...column-char ts/ you may come up with a better solution.
With the pivot chart approach you won't be able to get rid of the dates on the X axis, I think, but tricking with your original data table might be an idea.
1. added a dummy ...
Started 2 days, 10 hours ago (2009-12-18 05:20:00)
by Andy Pope
sounds like you need to search the forum for the term " gantt" chart.
Started 2 days, 11 hours ago (2009-12-18 04:13:00)
by teylyn
Hi avidcat,
it might be possible, but it would be a lot easier to figure out if we could have a look at your data layout and the chart produced by it. You could possibly use a helper column, populated only with values that meet certain conditions, and then apply that helper column as the source of the data labels.
Could you mock up a sample?
|
|
Hot threads for last week on Excel Charting::
Started 4 days, 5 hours ago (2009-12-16 09:55:00)
by zbor
Like this?
Variance%20Tracking%20TEST(1). xlsx
Started 1 week ago (2009-12-12 20:54:00)
by shg
Quote:
The question is how can avoid this?
Yes: Don't merge cells.
Started 4 days, 4 hours ago (2009-12-16 11:09:00)
by Andy Pope
does the pc have any print drivers installed?
Started 5 days, 2 hours ago (2009-12-15 12:45:00)
by Andy Pope
You just need to plot an xy-scatter. The divider lines can either be a additional series, gridlines or the axes.
Best if you lay your data out in 2 columns.
X values in first column
Y values in second
Placing a description over the Y values and including this in your selection will make creating the chart with the data correctly recognised simpler.
Started 2 days, 21 hours ago (2009-12-17 17:55:00)
by teylyn
Hi Rob,
like this maybe? see attached.
It's not the cleanest and with a little more time and study of this http://peltiertech.com/WordPress/clu...column-char ts/ you may come up with a better solution.
With the pivot chart approach you won't be able to get rid of the dates on the X axis, I think, but tricking with your original data table might be an idea.
1. added a dummy ...
Started 3 days, 12 hours ago (2009-12-17 02:49:00)
by nguyeda nguyeda is offline Registered User
I want to create a LINE chart that compares the trend of Avg Man Hours. I only have so much data so far.
I want to see the lines overlapping as much as possible but over the correct dates.
Notice that the line MH data is correct in the chart but the dates do not match up.
What do I do?
Started 2 days, 6 hours ago (2009-12-18 09:11:00)
by Andy Pope
It's not clear from your post what the actual problem is.
Does the formula return error, wrong information?
Where is the reference to the second file?
Started 2 days, 6 hours ago (2009-12-18 08:25:00)
by teylyn
Hi,
you need to arrange your data in two columns:
column label x - height
column label Y - weight
Then select the data without the labels and create an XY scatter chart.
In a separate column, which could be adjacent/before the X column, enter the names. Then use the XY Chart Labeler add-in to associate the scatter chart data points with the names.
The add-in can be downloaded ...
Started 1 week, 3 days ago (2009-12-09 17:02:00)
by rwbrich Registered User
Good Afternoon
would like to have the column color diferent for selected rows
in a column chart.
e.g.
col a col b
CEE-male 60%
female 40%
CENG-male 75%
female 25%
.
.
.
chart shows the male and female columns in the same color
is there a way to have the female column a different color/
without...
Started 6 days, 7 hours ago (2009-12-14 07:21:00)
by teylyn
Hi smileanandh.
welcome to the forum. However ....
Your post does not comply with Rule 1 of our Forum RULES . Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed ...
|
|
Size: 408 bytes
