| Thread | Last Post | Replies |
|
| hide or show a series with a button | 06 Dec 2007 04:36 GMT | 1 |
I have a Chart with 8 different series of data. I would like to have a button to 'toggle or hide' the display of each series one at a time. Is this possible?
|
| Shifting Data Points | 05 Dec 2007 19:46 GMT | 1 |
I have a graph with two lines. I want to shift one of the lines to the right, while mainitaing the origianl two lines. How do I do this. I have data points listed in the spreadhsheet , but I want to pick up one line graph and shift it to the right by 2 spaces, but keping the ...
|
| conditional formatting within chart | 05 Dec 2007 19:05 GMT | 4 |
I've got a bar chart (the lines flow left to right) that i update every week...the current bar chart i'm using has some sort of conditional formatting where if the number is >0, the bars are all green, but if the number is <0, then all the bars are red...for some reason my ...
|
| Change base of bar chart | 05 Dec 2007 19:04 GMT | 1 |
I have a bar chart. It's a standard little bar chart. The bar chart's base starts at 0 zero. What if I wanted to change the 0 to some other number, like 100 so that values less than 100 would fall below the baseline?
|
| Chart Macro | 05 Dec 2007 16:37 GMT | 1 |
I have a worksheet with ten charts. Is there a way to hide the charts and have a macro button so that the chart appears in its own window? The charts should all be the same size. If this is possible could you provide a step by step approach?
|
| Can you dynamically expand the time range to the series data added | 05 Dec 2007 16:06 GMT | 2 |
I'm trying to create a chart for work. I have the chart with about ten years of dates. A worker will fill in the data (byte count) as the Y-Axis data. The dates are the X-Axis data. I have the dates already filled in (from 1/1/2008-12/31/2029).
|
| Increase space between values on y coordinate | 05 Dec 2007 15:42 GMT | 1 |
I have a chart with months along the x axis and temperature readings along the y axis. Several years are plotte din different colors. There is also a horizontal line representing the annual average for each year. The problem I'm having is that, the annual averages are very ...
|
| defined names and setsourcedata | 05 Dec 2007 15:39 GMT | 2 |
I have formula in a cell that creates a string. The string can represent several defined names strung together, delimited by a comma. For example, the formula in cell D21 returns: AX,SY,KS
|
| Excel 'bubble' chart where colors are used instead of bubble size | 05 Dec 2007 15:33 GMT | 3 |
I am trying to create plots from 3-D data where the first two columns determine the X & Y coordinate of the plotted symbol and the third column (Z) gives the value which is represented by the color of the symbol. This is very similar to the bubble plot where the size of the ...
|
| Any ideas for making this graph type easy for other users? | 05 Dec 2007 12:47 GMT | 5 |
I have an idea for a chart type that I can almost construct in Excel, except that I am frustrated by the fact that Excel columns have only a single option for borders: all the way around, or none. It would be effectively a graph of interval Y axis against category X
|
| Copy a graph to a new workbook | 04 Dec 2007 19:51 GMT | 7 |
A worksheet was created that contains data with an associated graph. The data and the graph were copied and pasted into a new workbook. The data on the graph points to the original workbook. Is there an easy way when you copy and paste to have the graph point to the data in the ...
|
| How do I set up a stacked chart | 04 Dec 2007 17:50 GMT | 2 |
I have the following data: Fall 05 Spring 06 Summer 06 Exc Org 48% 56% 44% Good Org 52% 44% 66%
|
| Copy Charts | 04 Dec 2007 15:07 GMT | 5 |
I know this is simple, but I cannot remember how. I want to copy a chart into another worksheet, but do not want to keep the links, just the picture and data as it is.
|
| How to change check box name using mouse and keyboard | 04 Dec 2007 14:36 GMT | 2 |
I have a chart with many forms controls on it (check boxes). I need to change the names of some of check boxes from system assigned "Check box nn" to more meaningful, like "cbBrightness". I know I can write a macro which will do the trick for me:
|
| formatting lines in an excel graph | 04 Dec 2007 14:01 GMT | 4 |
using excel (Microsoft office 2007), when I try to format a line in a graph my worsheet either takes forever, or completely freezes before I can edit the line. All I want to do is change the line from being a red line to being a dotted black line, for example. The data that is ...
|