Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart x axis labels show up as range
In chart creating code I am trying to set the x-axis values using:
..SeriesCollection(1).XValues = xVal xVal is a declared range that is basically an array of specific column headings selected from many. xVal is also used to choose the data columns used in the chart. When the chart is generated the x axis labels are the actual range values "B!$H$1, B!P$1, etc" I need the labels to be the actual values from the cells. this seems a simple thing but it eludes me! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart x axis labels show up as range
Sorry, xVal is a declared string, not a range
On Dec 12, 3:45 pm, Robert H wrote: In chart creating code I am trying to set the x-axis values using: .SeriesCollection(1).XValues = xVal xVal is a declared range that is basically an array of specific column headings selected from many. xVal is also used to choose the data columns used in the chart. When the chart is generated the x axis labels are the actual range values "B!$H$1, B!P$1, etc" I need the labels to be the actual values from the cells. this seems a simple thing but it eludes me! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show numbers on y-axis and percentages on data labels? | Charts and Charting in Excel | |||
Chart axis labels cut off | Excel Discussion (Misc queries) | |||
Don't want to show X axis labels. | Excel Discussion (Misc queries) | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel |