Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can not set Y Values in XY chart
Hello --
I use the following code to set X and Y values: g_strRangeSeries = "A2:A82" (calculated in prior code) strDataXValues = Chr(34) & "=Data!" & g_strRangeSeries & Chr(34) ActiveChart.SeriesCollection(1).XValues = strDataXValues This correctly places ={"=Data!A2:A82"} in Source Data | Series | X Values: The problem is with setting Y Values. g_strRangeYVal = "B2:B82" (calculated in prior code) strDataValues = Chr(34) & "=Data!" & g_strRangeYVal & Chr(34) ActiveChart.SeriesCollection(1).Values = strDataValues This incorrectly places ={0} in Source Data | Series | Y Values: Can someone tell me why my method works for X, but not Y? Thanks in advance for any info. Larry Mehl --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can not set Y Values in XY chart
.... answered in the charting group.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ L Mehl wrote: Hello -- I use the following code to set X and Y values: g_strRangeSeries = "A2:A82" (calculated in prior code) strDataXValues = Chr(34) & "=Data!" & g_strRangeSeries & Chr(34) ActiveChart.SeriesCollection(1).XValues = strDataXValues This correctly places ={"=Data!A2:A82"} in Source Data | Series | X Values: The problem is with setting Y Values. g_strRangeYVal = "B2:B82" (calculated in prior code) strDataValues = Chr(34) & "=Data!" & g_strRangeYVal & Chr(34) ActiveChart.SeriesCollection(1).Values = strDataValues This incorrectly places ={0} in Source Data | Series | Y Values: Can someone tell me why my method works for X, but not Y? Thanks in advance for any info. Larry Mehl --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Office 2007 can't see chart series values unless chart unprotec | Charts and Charting in Excel | |||
Only chart numerical values, not error values | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Troubles with asigning x values and values to a chart | Excel Discussion (Misc queries) | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |