| Thread | Last Post | Replies |
|
| Possible to chart data for dates implicit within a range? | 01 Sep 2005 22:11 GMT | 1 |
I have a list of computer programs with start and end dates for each. I need to determine how many programs were running on my system on any given day. Can I get this data for individual days between the start and end dates without creating columns for each intermediate day? Ex.: ...
|
| help with dynamic range | 01 Sep 2005 21:59 GMT | 1 |
I wanting to know if this is possible without switching the way I have data entered into a spreadsheet. The spreadsheet I have has column headings of each month, Jan thru Dec, with a total column at the end. Down Column A are row names for several departments. So basically ...
|
| combination area and line needed | 01 Sep 2005 21:55 GMT | 6 |
I am using '03, and need a chart that has a few series in area buildup view (filled sections which build on top of themselves), with one other series that appears over that area as a line. Any help? Thx.
|
| How can I create a chart using stacked & reg columns together? | 01 Sep 2005 20:50 GMT | 1 |
I need to create a chart using 2 axis (which I can do already). The part I am struggling with is on the primary axis, I need 1 standard column and 1 stacked column side-by-side. I can do a dual axis with 1 stacked column and 1 line on the primary, but not a column. Any help is ...
|
| Dynamic Charts | 01 Sep 2005 15:16 GMT | 4 |
I have a 2 column data set that I need to chart. The last row of this dataset can increase or decrease. I need the chart to reflect the values dynamically. For this, I am calculating the last row value in the macro and transferring
|
| show in a excel graphic a total percentage for 5 diff data fiels | 01 Sep 2005 13:26 GMT | 1 |
I need to make a graphic showing the percentage for 5 diff fields, e.i. pmc total 16, nmcs total 10, pmcs total 5, nmcm total 0, and nmcs total 3, this it should be based on a total of 100% combine. at this tiem I can't figure out the formula how to make read all 5 columns, ...
|
| Keep y-axis aligned | 01 Sep 2005 13:23 GMT | 2 |
I have two area charts. One is above the other on the page. I want to keep their respective y-axis lined up with one another but I cannot figure out how to do this. The data that the charts show is unknown to me and can change so I
|
| How do I show range of data in an area chart? | 01 Sep 2005 13:12 GMT | 1 |
I am trying to show various toxins across the bottom of a chart, and ranges (from 0.001 to 1,000,000) on the left-hand side...OR whatever will work. I have ppb-PID (0.01-1,000), IR (0.50-1,500), Electrochem (0.1-1,005), ppm-PID (0.1-10,000), FID (0.75-50,000), Tubes (1-150,000), ...
|
| graph | 01 Sep 2005 13:03 GMT | 1 |
When I group data or hide data. The graph series dissappears and the graph nolonger shows the data. Is there a way round this without just putting the data elesewhere
|
| How do you set all graph data points to black (multiple series)? | 01 Sep 2005 13:00 GMT | 1 |
I have multiple series on a chart, all with different marker shapes as desired. How do I globally set all the data point colors to black without picking each series in turn and setting a custom color.
|
| missing data points causes my line graph not to connect | 01 Sep 2005 12:48 GMT | 6 |
I am doing a simple line graph for data points over 200 days, however for some of the days I do not have data, therefore when I create a graph it where there is missing data the line does not connect, there should be an easy way to fix it, but I can't figure it out. I tried to ...
|
| Colums | 01 Sep 2005 11:42 GMT | 1 |
I am trying to display a set of data that shows figures for each month over the past year, so 12 individual colums in total. I am only able to display 9 months worth of data. Can anyone help?
|
| can you create a break in the chart scale | 01 Sep 2005 10:51 GMT | 1 |
Is possible to change the scale of the chart to reflect a large range of data ie creat a break in the scale? I have a data set that consists of variables ranging from 25 to 0.1, there are roughly three variables that are in between 20 - 25 and the
|
| Bar chart: change color of a bar to red if value > x? | 01 Sep 2005 07:49 GMT | 4 |
Hi, Group! Is there a way to change the color of all or a group of bars in a bar chart, depending on their value? E.g. if the value is below 2.5, the color shall be green, above 2.5 the color of the whole bar should be red.
|