| Thread | Last Post | Replies |
|
| is there a way to have data labels on top and inside of a bar? | 21 Oct 2005 19:47 GMT | 3 |
I'm trying to complete a simple chart that includes both total number and total cost of a given. Is there a way to have a data label and a label on the inside of a bar?
|
| Macro to Create a Chart and Update it Automatically | 21 Oct 2005 17:42 GMT | 2 |
I wonder if you can help me to create a macro to make a chart and update it automatically when I add more information in the following rows. Basically, this is the table a have (see below) and I just want the column “C” and the column “E” have a chart. Where the column “C” is the ...
|
| Newbie...need more space between entries on X axis | 21 Oct 2005 17:28 GMT | 1 |
I know this should be simple...just can't find it. I have a basic bar chart with four values for each of our ten clients. The client names are on the X axis running horizontally and their sales, etc. are on the Y axis.
|
| Linking a horizontal set of cells to a vertical sets of cells | 21 Oct 2005 15:19 GMT | 2 |
What is the quickest way to link a horizontal sets of cells to a vertical sets of cells? I have a spreadsheet where my values I want to plot are horizontal. I want to link these range of horizontal cells to a another s/s where the range is
|
| Retrieve point address from scatter plot by clicking? | 21 Oct 2005 14:02 GMT | 3 |
Basically, I'm trying to retrieve several selects peaks and troughs from an oscillation data set with multiple amplitudes. It would be optimal to click on the point and transfer the coordinate values to the spreadsheet.
|
| how to ensure that the chart will be deleted after i delete data | 21 Oct 2005 13:59 GMT | 1 |
i want that the chart i have created from my data should be deleted after i delete the data and there should be no blank chart or legents visible.
|
| Can I Apply Conditional Formatting to a Chart? | 21 Oct 2005 13:56 GMT | 3 |
I don't agree with my boss's ideas regarding Excel Charts - I think that they are to cluttered and become less effective. So, I would like to apply conditional formatting via a checkbox to "turn off"(apply white/transparent properties)to one or more series in a chart, effectively ...
|
| setting x-axis labels | 21 Oct 2005 13:27 GMT | 2 |
I have been trying to select the x-axis data labels. It works ok up to a point then clears out all previous selections. Some of the charts will allow me to select all the data ranges I want but others don't. Why is this happening? I have a worksheet with 35 charts on it. Is ...
|
| Altering the range that is plotted by a chart via VBA | 21 Oct 2005 10:59 GMT | 4 |
Good morning all. I haven't really done a huge amount on charting, so I'm sure you'll think that these questions are a bit simplistic, but here goes! I plot a chart from a worksheet that contains three columns of data - the X
|
| Simple one, its just that I'm thick! | 21 Oct 2005 09:56 GMT | 2 |
How do I have a bar graph where 2 sets of information are laid over each other. Similar to a stacked chart but with both sets starts on 0. Please help! Similar to the 3-D column standard option but not in 3-D!!
|
| Graph colors automatically change | 21 Oct 2005 09:46 GMT | 1 |
I am trying to create a graph, where each month the numbers will be updated. I want the positive numbers to show up green in the graph, and the negative numbers to show up red on the graph. I know that I can adjust this manually, but this will be linked to 200 or so department ...
|
| Secondary Axis | 21 Oct 2005 09:39 GMT | 5 |
I need to plot a secondary axis on a chart. MS instructions for plotting secondary series listed below. The problem is there isn't a "Selected Data Series" on the Format menu. I am using XP, how do I get this? When the range of values for different data series in a 2-D chart ...
|
| Secondary axis with VBA | 21 Oct 2005 03:56 GMT | 2 |
I'm using the following VBA code and I never see the secondary value axis. Can anyone figure out why??? Excel 2003, VBA Thanks,
|
| problem with column charts and two Y axes in Excel 2003 | 21 Oct 2005 03:04 GMT | 1 |
I've used previous versions of Excel for column charts a fair bit, and it seems like something doesn't work in Excel 2003. I want to display two data series next to one another in a column chart, and each data series needs its own Y axis (they are on different scales). I can get
|
| how do i chart a 24 month moving average of sales shipments | 20 Oct 2005 13:14 GMT | 2 |
I need help creating a graph that shows a 24 month moving average of sales shipments. lburdette@nasonptc.com
|