Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis captions
Hi All,
I have a macro creating a column chart. It takes category axis captions from range("E1:AB1"), values from a selected row (row No is stored in a variable "sourcerow"), so my VBA line is: ActiveChart.SetSourceData Source:=Sheets(lapnev).Range( _ "E1:AB1,E" & sourcerow & ":AB" & sourcerow), PlotBy:=xlRows It works well except that in some cases only every second caption is displayed on the chart (E1 is displayed, F1 is left blank, G1 is displayed, H1 is left blank, etc.). The value columns are correct above the blank captions. I couldn't figure out any differences between correct and incorrect cases. How can I force to always display the whole caption range? Thanks, Stefi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
createing a dynamic array of buttons with captions loaded from she | Excel Discussion (Misc queries) | |||
Cell values as captions | Excel Discussion (Misc queries) | |||
How do I put captions on Excel charts? | Charts and Charting in Excel | |||
Can the captions for Option Buttons be drawn from other cells ? | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |