| Thread | Last Post | Replies |
|
| XValues - Why is code1 OK - but code2 doesn't work? | 23 Nov 2006 18:44 GMT | 3 |
Hi, I have a xlColumnClustered chart of three bars only, with values and names picked from cells not besie eachother. The first working code is based on recording, but I can't have RC reference in my code. The second code, I get "Unable to set the XValues property of the
|
| Adding Multiple Lines On A Secondary Axis? | 23 Nov 2006 11:17 GMT | 1 |
I am working with a line-column on 2 axes chart . Columns are charted on the primary axis and a line is charted on the secondary axis. I am trying to add a second line to the secondary axis. Can anyone help? Thanks
|
| Adding a limit line | 22 Nov 2006 21:55 GMT | 2 |
Hi, I have an embedded bar chart. I wanted to add a lower limit line and tried from Drawing a line as a Line and also tried a line as a Connector. I can even colour the resulting line. However as soon as I click outside the chart, the line disappears.
|
| how do i graph in excel from a equation?? | 22 Nov 2006 21:33 GMT | 1 |
how do i graph in excel from a equation?? I'm trying to graph something as simple as y=30000x is there any way to do so without having to have a series of number????
|
| [in horz.bar+chart] Disply dates on value axis? | 22 Nov 2006 17:46 GMT | 2 |
Something about selcting - 'date option'. But, where, how?
 Signature Boswell
|
| Making a line span the full length of a chart | 22 Nov 2006 11:28 GMT | 1 |
i have a chart with primary and secondary axis (a bar and line format). I want to make the line span the whole of the chart, stopping at the edges of the chart not before. Is there a way of doing this without manually drawin it on? I cant seem to
|
| Bimodal histograms | 21 Nov 2006 21:37 GMT | 1 |
I ran descriptive statistics on data that listed the mode as being 86. The histogram had a bimodal pattern, with modes at 66 and 90. How did Excel calculate the mode on this data?
|
| Copy x axis | 21 Nov 2006 19:31 GMT | 2 |
Hopefully this ones easy!?!??! I have a chart where I want to dispaly the same x axis both at the top and the bottom of the chart. Is there a special character to throw in the "cross y axis at" box to
|
| Displaying incremental values in a bar chart | 21 Nov 2006 17:16 GMT | 1 |
In my bar chart i would like to visually show the delta between two adjacent bars. Is there a way to obtain this result automatically? Thanks, Stefano
|
| Add vertical lines to a line chart (already has 2 Y axis) | 21 Nov 2006 16:19 GMT | 3 |
Hi, I have a report I update each month. And while most of the information is based on numbers one of the series is a percentage, so has it own axis. I've set up the spreadsheet so that each week when data is added then another part of the spreadsheet shows it, this part of the ...
|
| Use values instead of labels on X-axis in Area/Stacked Area Charts | 21 Nov 2006 16:14 GMT | 1 |
When building a stacked area chart, independent of how the linked cells are formatted, the chart uses the x-axis values as simple text labels. Since my values are not equally spaced, this distorts the plot, and I have not found any method through the help menus to change this ...
|
| Plotting means and standard deviations I already have | 21 Nov 2006 16:10 GMT | 4 |
I have a chart that I just cannot figure out how to graph. It is some survey results and the mean and standard deviation of each question. I want the horizontal axis to list 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0, 4.5,
|
| How do I put Information in a Line chart? | 21 Nov 2006 15:38 GMT | 1 |
I have three sets of information I want to put in a line chart. How do I do that?
|
| Scroll Bar from horizontal to vertical orientation | 21 Nov 2006 14:45 GMT | 1 |
I have a horizontal scroll bar in the lower left corner of a chart... not linked to a macro, but to a cell value for its control. I would simply like to convert it from its horizontal posture to a vertical placement so that I can move it into another area on the chart's y-axis
|
| Resizing many charts | 21 Nov 2006 08:39 GMT | 5 |
I need to resize a bunch of charts (all in one sheet) so that they have equal sizes. Is there a way to automatically do this? The best way I could think would be if I created a macro, where I could manually type in the dimensions, but I don't even see a way to do that. Can I only
|