| Thread | Last Post | Replies |
|
| Dynamic ranges | 08 Sep 2006 20:39 GMT | 2 |
I'm doing one thing wrong and I can't see the solution I believe that my problem is defining the x-axis in the dynaminc range. I can get the number to start at the right point - however I'm getting blanks on the right side of the graph - like it thinks there are numbers to graph ...
|
| Font error message | 08 Sep 2006 20:28 GMT | 19 |
When trying to make a copy of a worksheet containing two charts, the following message comes up: "No more font may be applied to this workbook." On one of the charts, three axes, two Y and one X, are resized by Excel. When trying to resize the axes fonts down again, the ...
|
| Pivot Tables/Charts | 08 Sep 2006 18:34 GMT | 1 |
I am creating a pivot table chart from a spreadsheet and I am sorting the "x" axis by date(chronological order) and item number. However, I only want the item number to be displayed on the "x" axis in the chart. How do or can this be done?
|
| conditional formatting in graphs | 08 Sep 2006 14:30 GMT | 1 |
How can we auto colour columns according to their value? For example, the value is >3.5, then the col turns green, if <2.5 it turns red. Similar to cell changes and conditional formatting, I suppose.
|
| Outside Label Position not listed | 08 Sep 2006 10:28 GMT | 1 |
I have 2 charts in a workbook. The first Chart has Outside End as a label position. The second chart doesn't have this option. I don't know why one would have it and the other not. Help please!!??
|
| Switch axis | 08 Sep 2006 07:48 GMT | 1 |
How do I switch the X axis data to be on the Y and vice versa? Thx! Denise
|
| HELP ASAP PLEASE!!! | 08 Sep 2006 07:45 GMT | 1 |
I am trying to make a chart for my science class. I have never used excel on my computer at home before, and it won't let me enter any text. SOMEBODY PLEASE HELP ME!!!!!
|
| Data points going from axis to axis | 07 Sep 2006 17:04 GMT | 2 |
Without necessarily deleting the chart and then recreate a whole new chart, how can I get the data points to revert back to being in the center of all columns rather than equally spaced starting from the left axis to the right axis?
|
| Bar Chart with bar data and another bar showing a range of data | 07 Sep 2006 16:44 GMT | 2 |
I have to create a chart that has three columns that I would like to show as two bars,the columns are one with a fixed amount and the other two with a negative to positive range. Do you know how this could be done? Ive included a sample of the data, the first numeric column would ...
|
| Save user-defined chart types in a shared Excel template? | 07 Sep 2006 14:07 GMT | 7 |
I am trying to create a template to be distributed throughout the company to aid in the creation of standard charts -- colors, patterns, fonts, etc. Unfortunately, Ihave not been able to get the user-defined chart types to save with the template. Is it possible to do this? I'm ...
|
| How do I produce Excel graphs for triangular (ternary) plots? | 07 Sep 2006 08:58 GMT | 1 |
I'm interested in drawing 2-D graphs of equations with 3 variables - a triangular ternary graph would be good. Are there any add-ins for Excel that would allow me to do this?
|
| Pie Diagrams | 07 Sep 2006 08:55 GMT | 1 |
Can Two range of data be reflected in a pie diagram? Eg., total region wise sales is devided into 2 parts, achieved till date and target remaining to be achieved.
|
| Points with the same value lie on top of each other - displace, move | 07 Sep 2006 02:02 GMT | 1 |
This question was asked a few years ago by someone else: http://groups.google.co.uk/group/microsoft.public.excel.charting/msg/f335a4916f3440fc Basically, I am using a line chart for a 'wrong' purpose. X axis values are actually categories and data points are not joined by lines. I ...
|
| Multiple data overlay | 07 Sep 2006 01:56 GMT | 1 |
I have 4 sets of data that span the same period of time, 1 week, but all data points were not collected at the same time, nor at the same interval. So, for the first set of data I may have 400 points, while for the second set of data - 700 points, etc. Time is on the X axis and ...
|
| Comparing more than two variables | 06 Sep 2006 20:32 GMT | 2 |
I have some research data I need to tally and chart. I am looking at a group of subjects that answered a 7-question test. I want to tally the responses, and tally the total instances of each one compared to the others (like how many answered yes to 1, 2, and 3 (or any other ...
|