Search results

Again, you do not understand the problem. Grab the data table and try to move it - you can't. I don't want to REMOVE, just move to a different location on the page, say further below or right or left of the chart.

sure. Though had to convert to .xls and if a setting on your computer, it may not accurately reflect the issue, but I'll try anything at this point. See file: TEST.xls

While that might be one way to resolve the problem, I am not looking for anything so complicated. Two of us can run identical data and request a chart with data table. One builds with the data table and graph bound together, one does not. Why? and how do I switch back and forth - that is the...

The chart tab contains both the graphic representation and a table which shows the data numerically. The top of the data table is bound to the x-axis of the chart. I wish to separate them in order to move the data table independent of the chart. Both contain the same data and are linked to a...

I am using Excel within Office 2007. When I add a data table to a chart, the data table is docked on the x axis of the chart. A coworker's data table is separate from the chart, allowing for additional flexibility. We have been unable to identify how to convert one type to the other, though...

Background color cannot be set to transparent. Cell fields may be set to transparent but not the background. You can set to white (is that what you mean?) Only Alt background can be set to no color. However, I have tried multiple variations, but neither have solved the problem.

I am having a problem with setting the alternative row color. Some reports work and some do not. I have both types defining the detail section. Is there some setting I need to check? Everything looks good and consistent as far as I can tell. It appears to ignore the background setting on...

Well bully for you. I can't believe you even took the time to respond to my query. Fortunately I identified a solution without your "help"

I have a spreadsheet where I was forced to merge cells together. I then have a second spreadsheet in which I enter data. The first sheet with merged cells autopopulates when the data is entered into the second sheet. I know I can write a formula to pull in the data, but because the...

Thanks, however, I just decided to make life easier and put the 12 items in my main table. So now it's fine. Thanks for your consideration...

Since when is it required to link a form to a table? Forms can be linked to queries which are linked back to tables. I have built many applications this way without a problem. That's why this is so confusing, I'm doing nothing different from what I have done in the past, yet this is the...

I have a new build with a data entry form bound to a query which pulls from my "main" table and one linked table. The query pulls all the fields from the main table plus all the fields from the linked table. The primary keys for both tables are located in the query. The query runs fine. I...

Great! That's exactly what I need to see. Works great. Thanks :D thatlem

Although only an abbreviated version, I figured out that I needed to tell the computer to "look" at the selection in the data validation field. So I added a button, and substituted the Private Sub command. So after making the selection, they hit the "Go" button and it triggers the code to run...

I got it now, thanks thatlem

Yes, you are correct. Sorry for the memory lapse. However, after the change, the code still does not hide the worksheets as I would expect. Private Sub Worksheet_Calculate() If Sheets("Admin").Range("b1") = "DEN" Then Sheets("Dent Sum").Visible = True Sheets("ENT...

I am planning a file with about 30 worksheets, 3 for 10 different departments. To make it easier for staff, I would like to create a data validation list of the 10 departments and use this to drive what worksheets are visible or hidden. The simple version is below: Sub...

Actually the information you suggest does not address the problem. I am aware of the cell to cell relationship and fixing cell locations. This would appear to be more related to something that I can't see - maybe a hidden control character in the cell itself. I have run into this problem...

I have a formula that works fine. I copied and pasted into another cell. After, the copied formula does not work. The formula evaluator indicates there is a constant in the equation. I then built the same formula using the formula wizard, instead of typing it out, and the wizard pulls the...

That's what I was afraid of. Can you educate me on the code I would need to run this in a report. Thanks