| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Coding "Category (X) Axis"...
I'm running Access-to-Excel automation, and using Auto_Open in Excel to see
things like.. ActiveChart.ChartTitle.Text = " The Week" & TheWk Works fine. I want to "fill a label on the Chart" with a concatenation. Can I... ActiveChart."xxx???".Text = "ABC " & TheDay..as an Example. What would be the ""xxx???" for a "label" such as the "Category (x) Axis" TIA - Bob |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Coding "Category (X) Axis"...
Hi,
Macro recorder gave the majority of the code. With ActiveChart .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _ Format$(Now(), "dddd") & "'s X axis label" End With Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob Barnes" wrote in message ... I'm running Access-to-Excel automation, and using Auto_Open in Excel to see things like.. ActiveChart.ChartTitle.Text = " The Week" & TheWk Works fine. I want to "fill a label on the Chart" with a concatenation. Can I... ActiveChart."xxx???".Text = "ABC " & TheDay..as an Example. What would be the ""xxx???" for a "label" such as the "Category (x) Axis" TIA - Bob |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Coding "Category (X) Axis"...
Beautiful.
Thank you Andy, Bob "Andy Pope" wrote: Hi, Macro recorder gave the majority of the code. With ActiveChart .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = _ Format$(Now(), "dddd") & "'s X axis label" End With Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bob Barnes" wrote in message ... I'm running Access-to-Excel automation, and using Auto_Open in Excel to see things like.. ActiveChart.ChartTitle.Text = " The Week" & TheWk Works fine. I want to "fill a label on the Chart" with a concatenation. Can I... ActiveChart."xxx???".Text = "ABC " & TheDay..as an Example. What would be the ""xxx???" for a "label" such as the "Category (x) Axis" TIA - Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Getting a category x-axis to sort of "right-justify" | Charts and Charting in Excel | |||
| In a bar chart, how do I change the x-axis "category" labels? | Excel Discussion (Misc queries) | |||
| UDF Add-in New category in "Paste Function Dialog Box" | Excel Worksheet Functions | |||
Hybrid Mode
