charting - x axis labels problem

[shelspa]

I have a stacked column chart that plots monthly sums by two concatenated date fields using datepart. Example: Jan 04, Feb 04, Mar 04 etc. It works great. When I do a calculation on each data field to change the data to a percentage, the x axis date labels get jacked. The first shows normal then every other one appears as zero: Jan 04, 0, 0, 0. I can either do only one datepart for the x axis, or not calculate the plotted data. Ideas?

 

[GingerR]

what does the data table look like for the chart? can you please supply a sample so we can see what you're working with? i'm not clear on what you mean in your first sentence.

thanks--g

 

[shelspa]

Unfortunately the data table only shows microsoft's sample data. I found that in my concatenate statement, if I change the "/" to "\" between the months and years it works. Why in this chart and not other identical charts do I have to do this I have no idea. Every control, parameter, variable etc. is identical. I guess I'll live with the slightly different format.

 

[GingerR]

You can get your data from the Rowsource of the chart.

Here's a hint for the charts to get rid of the sample data. You can paste in your own "sample data".

in the chart properties (right-click on the chart object and select Properties), run the rowsource (the table or query you have the chart based on). when you're looking at the resulting datasheet, go ctrl+a and ctrl+c ("select All" and "Copy"). close that up. Close the Properties pop-up window. Double-click the chart, click in the upper-left cell of the datasheet (so it's all selected and black) and hit ctrl+v (paste). it will probably say "the areas aren't the same size" or something, just hit YES or OK or whatever, so it will paste. now view the chart in design mode, and you can see how it will really look with YOUR data. That way you can adjust the chart type, colors, etc more easily.