Seek Charting Tip

[[email protected]]

Hi,

I need an XL Charting tip ...


I have an example of what is working for me - and an example where I
need help.

The point of the first example is to give an indication of the tip I
need.

''''' What Works Great '''''''

I have the following data in a worksheet

rr bb 60
bb 80
dd cc 90
cc 100

Where using the Chart Wizard generates a footer that looks like this :


| bb | rr | cc | cc |
| rr | dd |

Which works great.


''''' Where I Need Help ''''''

When the data in the worksheet looks like this (singleton case)


rr bb 60

Using the Chart Wizard generates a footer that looks like this :

1

I want it to be consistent with the great-working example and to look
like this:

| bb |
| rr |

'''''''''''

Suggestions?

I'm building the Charts with VBA so a VBA solution is OK.

Thanks.

[Andy Pope]

Hi,

Would appear that you need at least 2 data points for the chart to give
you the double axis labels.
If you only have a single point you could fake it by using the following
formula ="bb" & char(10) & "rr"
in a single cell as the axis labels.

Cheers
Andy

[email protected] wrote:
> Hi,
>
> I need an XL Charting tip ...
>
>
> I have an example of what is working for me - and an example where I
> need help.
>
> The point of the first example is to give an indication of the tip I
> need.
>
> ''''' What Works Great '''''''
>
> I have the following data in a worksheet
>
> rr bb 60
> bb 80
> dd cc 90
> cc 100
>
> Where using the Chart Wizard generates a footer that looks like this :
>
>
> | bb | rr | cc | cc |
> | rr | dd |
>
> Which works great.
>
>
> ''''' Where I Need Help ''''''
>
> When the data in the worksheet looks like this (singleton case)
>
>
> rr bb 60
>
> Using the Chart Wizard generates a footer that looks like this :
>
> 1
>
> I want it to be consistent with the great-working example and to look
> like this:
>
> | bb |
> | rr |
>
> '''''''''''
>
> Suggestions?
>
> I'm building the Charts with VBA so a VBA solution is OK.
>
> Thanks.
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info