Hi,

I've got a little problem with drawing charts in Excel. I made a normal
line chart from a table like this:

Yesterday 215
Today 200
Tomorrow 215

The result ist a chart with Text on the X-axis and numbers on
the Y-axis (see graph1.png).
Now my problem is, i want to make a chart with text on the Y-axis.
But if i change the source data there are numbers from zero to one on
the Y-axis instead of text(see graph2.png).
Actually i want to make something like the bar charts, just with lines
instead of bars. Is there any possibility to do that?

Thanks,
Marco

Hi,

Have a look at,
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

Cheers
Andy

Marco Hemmerle wrote:
> Hi,
>
> I've got a little problem with drawing charts in Excel. I made a normal
> line chart from a table like this:
>
> Yesterday 215
> Today 200
> Tomorrow 215
>
> The result ist a chart with Text on the X-axis and numbers on
> the Y-axis (see graph1.png).
> Now my problem is, i want to make a chart with text on the Y-axis.
> But if i change the source data there are numbers from zero to one on
> the Y-axis instead of text(see graph2.png).
> Actually i want to make something like the bar charts, just with lines
> instead of bars. Is there any possibility to do that?
>
> Thanks,
> Marco
>
>
> ------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>

--

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

Nice tool, but it wouldn't work with me. I'm using Excel 2007
Is it possible that the tool would not work with this verison?
Are there any other solutions?

Thanks for your help
Marco

Andy Pope wrote:
> Hi,
>
> Have a look at,
> http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
>
> Cheers
> Andy
>
> Marco Hemmerle wrote:
>> Hi,
>>
>> I've got a little problem with drawing charts in Excel. I made a normal
>> line chart from a table like this:
>>
>> Yesterday 215
>> Today 200
>> Tomorrow 215
>>
>> The result ist a chart with Text on the X-axis and numbers on
>> the Y-axis (see graph1.png).
>> Now my problem is, i want to make a chart with text on the Y-axis.
>> But if i change the source data there are numbers from zero to one on
>> the Y-axis instead of text(see graph2.png).
>> Actually i want to make something like the bar charts, just with lines
>> instead of bars. Is there any possibility to do that?
>>
>> Thanks,
>> Marco
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> ------------------------------------------------------------------------
>>
>

Hi,

I assume by Tool you mean the chart labeler, which does work in xl2007,
in which case you can do the linking of data labels to cells manually.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

Marco Hemmerle wrote:
> Nice tool, but it wouldn't work with me. I'm using Excel 2007
> Is it possible that the tool would not work with this verison?
> Are there any other solutions?
>
> Thanks for your help
> Marco
>
> Andy Pope wrote:
>
>> Hi,
>>
>> Have a look at,
>> http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
>>
>> Cheers
>> Andy
>>
>> Marco Hemmerle wrote:
>>
>>> Hi,
>>>
>>> I've got a little problem with drawing charts in Excel. I made a normal
>>> line chart from a table like this:
>>>
>>> Yesterday 215
>>> Today 200
>>> Tomorrow 215
>>>
>>> The result ist a chart with Text on the X-axis and numbers on
>>> the Y-axis (see graph1.png).
>>> Now my problem is, i want to make a chart with text on the Y-axis.
>>> But if i change the source data there are numbers from zero to one on
>>> the Y-axis instead of text(see graph2.png).
>>> Actually i want to make something like the bar charts, just with lines
>>> instead of bars. Is there any possibility to do that?
>>>
>>> Thanks,
>>> Marco
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>

--

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

That is exactly what i was searching for.
Thanks for your help.

Cheers
Marco

Andy Pope wrote:
> Hi,
>
> I assume by Tool you mean the chart labeler, which does work in xl2007,
> in which case you can do the linking of data labels to cells manually.
> http://www.andypope.info/tips/tip001.htm
>
> Cheers
> Andy
>
> Marco Hemmerle wrote:
>> Nice tool, but it wouldn't work with me. I'm using Excel 2007
>> Is it possible that the tool would not work with this verison?
>> Are there any other solutions?
>>
>> Thanks for your help
>> Marco
>>
>> Andy Pope wrote:
>>
>>> Hi,
>>>
>>> Have a look at,
>>> http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html
>>>
>>> Cheers
>>> Andy
>>>
>>> Marco Hemmerle wrote:
>>>
>>>> Hi,
>>>>
>>>> I've got a little problem with drawing charts in Excel. I made a normal
>>>> line chart from a table like this:
>>>>
>>>> Yesterday 215
>>>> Today 200
>>>> Tomorrow 215
>>>>
>>>> The result ist a chart with Text on the X-axis and numbers on
>>>> the Y-axis (see graph1.png).
>>>> Now my problem is, i want to make a chart with text on the Y-axis.
>>>> But if i change the source data there are numbers from zero to one on
>>>> the Y-axis instead of text(see graph2.png).
>>>> Actually i want to make something like the bar charts, just with lines
>>>> instead of bars. Is there any possibility to do that?
>>>>
>>>> Thanks,
>>>> Marco
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>
>