| Thread | Last Post | Replies |
|
| Auto Scale Chart Macro -- Any improvements please? | 19 Feb 2007 18:35 GMT | 2 |
This is the best way I've found to correctly scale a chart -- the only way I found to exclude a chart interpolating with #NA cells was to delete those cells containing #NA, and run the chart. This takes a long time on my computer. Wondering if there is a better way. This macro ...
|
| numbers on chart axis showing twice | 19 Feb 2007 18:31 GMT | 1 |
Axis on the pivot chart are showing up twice.
|
| Excel Charting: Multiple data series on two axis instead of one? | 19 Feb 2007 13:56 GMT | 2 |
I had some graphs using the custom line/column format in excel with 2 data series. When I tried to add in another line to make it 2 lines and a column, the 3 data series all become based on the left axis. Is there anyway that I can make 2 data series base on one axis and 1 data
|
| numbering rows | 19 Feb 2007 08:45 GMT | 1 |
i need to number my rows in a seperate column to count my inventory, but when i filter my coulmns and do a custom filter my number column filters along with the others even if the number column is not filtered???????????????
|
| Graph in Excel has one data label missing | 19 Feb 2007 08:39 GMT | 1 |
I havea very simple chart made into a graph. There is one data label that does not show. All of the others are fine. How can I get it back. I checked the table and the data is there... the bar is even there but no label. Thanks to anyone that can help.
|
| Pop up menus in Excel | 19 Feb 2007 08:39 GMT | 1 |
I want to hide or disable the pop up menu that appears everytime i right click a worksheet tab. is this possible?
|
| distortion while printing | 19 Feb 2007 08:09 GMT | 1 |
i have placed a combination chart on on the worksheet which is aligned with the cells. however when printing the chart get misaligned with the cell distorting the whole picture. please help. thanks!
|
| how can i put graphs on one sheet | 19 Feb 2007 08:05 GMT | 1 |
I want to draw a three lines with their coordinated on one graph sheet
|
| Changing the width of the legend key | 19 Feb 2007 04:14 GMT | 1 |
Subject pretty much says it all: Is there a way to change the width of a legend key (the little square symbol that typically appears to the left of the legend text)? This question is in reference to a column chart in Excel 2003.
|
| duplicate table just values not formulas in the table | 18 Feb 2007 12:18 GMT | 1 |
duplicate a table with the just values not formulas in the table so that I don't have to readjust the formulas as when they are copied and pasted they are often meaning less ie referring to the wrong cells
|
| semi log graphs | 17 Feb 2007 18:40 GMT | 3 |
I am interested in making Semi-log graphs with the X axis having the log scale. I understand that this can be done in XY scatter. My x-axis values range from .002 to .312 Do i still need to format my X-axis with a MAX of 10?
|
| Charting in a cell | 16 Feb 2007 17:39 GMT | 10 |
Does anybody have some information in creating a line chart that resides within a cell that reflects the pattern of a row or column of numbers? Someone at work referred to such a thing as a "spark line". Any VBA out there to help with something like that ?
|
| how can i put graphs on one sheet | 16 Feb 2007 17:35 GMT | 1 |
I want to draw a three lines with their coordinated on one graph sheet
|
| Copy and Paste Chart as Picture into another workbook or worksheet | 15 Feb 2007 23:47 GMT | 1 |
I've been looking in the newsgroups but can't find an answer. I'd like to copy a chart from one workbook and paste it in another -- but without the source reference. In other words, once I've created the chart in Excel in one workbook, I'd like to copy and paste the picture of ...
|
| Auto Scale X axis doesn't work with "" values in cell | 15 Feb 2007 22:34 GMT | 3 |
First of all, thanks to tushar: http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html I'm trying to get a chart to work with the basic ranges defined as this: XValues =OFFSET('Basic Range'!YValues,0,-1)
|