Topics Search

Formatting Charts

Formatting Charts
Views: 186
A chart created using the New Form dialog box is positioned on a form. As such, the form acts as its parent. The chart can only fit inside of the form. Based on this, you can enlarge a form to make available more space for the chart. After enlarging and/or heightening a form, you can increase the side of the chart to have a bigger picture and better appreciate a chart.
Sponsored Links:

Similar posts...


Nested Charts In Excel

Nested Charts In Excel Icon
I am trying to place 3 stacked column charts into one single chart sheet, I have been able to do this using excel itself but I would like to automate the process from access.

currently I am able to create the the required charts, but not able to add them into one single chart sheet here is some of my current code:

Set container = Charts.add
Set graph = Charts.add
graph.ChartType = xlColumnStacked
graph.SetSourceData Source:=ws.Range("$B$" & int_start & ":$E$" & int_end)
graph.PlotBy = xlColumns
graph.location Where:=xlLocationAsObject, Name:=container.Name

the last line constantly gives me an error,

Change the appearance of a control by using conditional formatting

Change the appearance of a control by using conditional formatting Icon
Conditional formatting allows you to selectively highlight certain data on your form or report so that it is easier to understand. For example, you might want to format negative numbers in a red font to make it clear that those records need further attention.
You can set conditional formatting for a text box or a combo box control. You can change the formatting based on the control's own value, or you can use an expression to change the formatting based on the values contained in other fields or controls. On a form, you can use conditional formatting to disable a control, and you can cause the formatting of a control to change when the cursor is positioned in that control.
What do you want to do?:
*Apply conditional formatting to a control based on its own value
*Use an expression to apply conditional formatting to one or more controls
*Change the formatting of a control on a form that has the focus
*Remove conditional formatting from one or more controls
*Create alternating row colors on a report

Multiple column charts for the same query

Multiple column charts for the same query Icon
I have a query in the format

Month | Type | TypeCount
2 | A | 3
2 | B | 4
2 | C | 5
3 | A | 4
3 | B | 4
3 | C | 6
4 | A | 7
4 | C | 2
4 | D | 1

I want to create charts (or pivot chart view) such that first chart display data only for A - that is, count of Type for each month, then another chart with data only for B and then another chart only for C.

Also, I want these three charts on the same report/form - which ever is better.

Conditional Formatting vs. VBA Formatting

Conditional Formatting vs. VBA Formatting Icon
I have been researching this for some time now but haven't received any sound advice on whether it is faster to perform formatting on text boxes in a report via VBA or the built in Conditional Formatting.

The reason I ask this is that I have a report with quite a few text boxes that currently all have some sort of Conditional Formatting on them (Not all have the same Conditional Formatting). I know that when you only have a few controls that require Conditional Formatting, the built in solution in Access 2007 should be sufficient, however when the number of controls grows and when the report has multiple records that require each control to be handled on each record, the Conditional Formatting becomes very slow (much like receiving 1000 paper cuts) and renders the report as pointless considering a user must run it for 10's of minutes to an hour to complete.

So, with that said, I am really just looking for anyone's suggestion as to whether I should invest some time in the VBA coding to do what the Conditional Formatting does, or do I just go back to the requestor and let them know that formatting all these fields is too much for the system to handle.

Customizing Charts

Customizing Charts Icon
In our introduction to charts, we created one with standing rectangular boxes. This is called a column chart and is only one of the types of charts available. Microsoft Access (indeed Microsoft Office) provides many other flavors you can use, depending on the type of analysis you want to perform. When starting a (new) chart, in the third page of the wizard, you can select the type of chart you want. After the chart has been created, you may prefer another type of chart. In most cases, you can change the type of chart, easily.

MS-Access and Graph Charts-2

MS-Access and Graph Charts-2 Icon
Access Reports are excellent in presenting information in Numbers and Text. But, Charts goes one step further in providing information in the form of pictures and a quick look at them says it all.

Relationships pivot charts

Relationships pivot charts Icon
I am having problem creating charts or pivot charts because the data being used is the ID's from the combo boxes, so I unable to see text. I have been advised to create another query using the table concerned and just include the fields I need to show text.

But when I try this I get an error 'Type mismatch in expression' and I think this maybe due to my relationships being incorrect?

If I have a Main table and connect the othertableID's with the same othertableID's to the Main table is this correct?

VBA conditional formatting

VBA conditional formatting Icon
I have read up about conditional formatting and understand the *concept* clearly (I think). However, is it possible to display conditional formatting of a subform in datasheet view on a form? If so, as I need to have more than 3 (or 4 if default is used) colours?

Fonts and formatting

Fonts and formatting Icon
Learn the following topics: 1)Change the font, font size, or font color
2)Add formatting to your document by using the Mini toolbar
3)Apply bold, italic, or underline formatting to text

Conditional Formatting Problen

Conditional Formatting Problen Icon
Access 2010, Windows 8 Release Preview

I'm having problems setting the format for the fore color of fields that meet the criteria in conditional formatting. I want the field to be disable. In fact I set the Enabled property for the field to No and the Locked to Yes.

I only want the Fore Color to change if they meet the criteria. But, if I set the field to enabled in the cell formatting the background changes to the back color that is alre4ady set in the formatting.

Is there a way to set conditional formatting without using the Conditional Formatting Rules manager?
I'm using the following as the criteria: