| Thread | Last Post | Replies |
|
| How do you hide a bar chart in Excel | 31 Oct 2008 22:35 GMT | 3 |
I have a bar chart that I would like to hide so I can possibly assign it to a macro and have it unhide and hide at the push of a button. Does anybody know if this is possible or any other ways to do it? Thanks.
|
| Thresholds | 31 Oct 2008 21:49 GMT | 1 |
I am plotting response times for commands and would like to plot multiple thresholds for these commands for different scenarios. Can I artificially add these thresholds to Pivot table data or charts?
|
| line chart using letters not numbers | 31 Oct 2008 21:44 GMT | 1 |
I am trying to graph reading levels for a class, the levels are letters not numbers. My data would include; student name, level, month, (example: Lily, U, September). I understand I need to make a line chart but how do I change the values to letters not numbers. Thank you
|
| Line Chart Format (Actual vs. Forecast) | 31 Oct 2008 21:38 GMT | 6 |
I have a line chart with weekly data for 2 years. Weeks on the X axis and Pounds on the Y axis. They represents actual and forecasted pounds. I need to show the first portion of the line (actual) with solid color while the rest of the line (forecast) with dotted line. We are ...
|
| Hiding zero values on a chart in Excel 2007 | 31 Oct 2008 17:48 GMT | 2 |
Hi all, I am trying to chart a series of data points from a table which looks up values dependant on the contents of a seperate cell with a drop down list. The table / chart is designed to be used until the end of the year, so
|
| Charting? | 31 Oct 2008 16:00 GMT | 2 |
I have a graph with two y-axis'. On one side I have lbs/hr. on the right axis I have efficiency for the production line. I want to add the cost for that specific day, but I only want to add the $ value by itself for the specific date. I don't want it to reflect along the y-
|
| intersection of 2 graphs | 31 Oct 2008 15:13 GMT | 6 |
I plotted 2 sets of data on the same set of axes.. now I need to find the intersection point of the two trendlines. Please let me know how I can do this (if I can)? This is probably very trivial.. really appreciate all the help.
|
| Addition of error bars creates black filled in areas on chart in 2 | 31 Oct 2008 13:27 GMT | 2 |
When i add custom standard deviation error bars in excel 2007, the graph shows a black fill in in some areas of the chart. The exact same chart in 2003 does not show this artifact. Anyone else experienced this?
|
| Help setting up Charts | 31 Oct 2008 12:34 GMT | 2 |
I have a spreadsheet with the following Column F, building name Each row on the spreadsheet is a member of staffs name In Column I, I have got the number 1 if the member of staff has been
|
| Pivot Table - there is an error message pop out during creation. | 31 Oct 2008 06:31 GMT | 1 |
Hi, I have a spreadsheet of data that has information from row 1 to row 54573. I tried to create a Pivot table for these data, but there is a dialog error message pop out when item being pulled to the PivotTable.
|
| Dates posted within a standard column chart | 31 Oct 2008 06:24 GMT | 1 |
I have a regular column chart with dates at the bottom, and the columns are the # of cases made per week. I'm trying to include the dates the Case specifications were changed within the chart. I only want to have a point within the chart showing the date it was created within ...
|
| Values on an Scatter chart | 31 Oct 2008 06:16 GMT | 1 |
I have a chart plotted with certain values for a whole month. I would like to show certain values corresponding to each date, but have them not be referenced by the x-axis. So, in essence I want to show the value for the date, and dollar value for the same date. Please help!
|
| Forgot to put in the Board of Directors on my org chart in Excel | 31 Oct 2008 06:12 GMT | 1 |
How can I add a top position to my org chart without having to redo the entire thing... we have 170 boxes and I left out the top dog! I don't have a budget for any new programs so I have to use what I have. Thanks!
|
| How do I fix transposed legend text? | 31 Oct 2008 05:51 GMT | 2 |
I've made a bar graph. Two of my bar labels in the legend have mysteriously transposed their text (e.g. I typed in "1 uM AF" and what appears on the chart is "uM AF 1"). I've tried referencing cells with the correct label and the same transposing happens. Why did this happen and ...
|
| How do I show a data table with legend keys in a line chart? | 31 Oct 2008 05:31 GMT | 1 |
I am having trouble inserting a data table with legend keys into a line chart that contains a horizontal target line. Can anyone help me?
|