Thread: Creating a Line Graph with Selectable Data

I am trying to create a chart for use in the hotel industry. I have 24
hotels that I would like to chart future room rates over the course of a
month. I want the ability to select the hotels I would like to compare on a
line graph. Possibly check the hotel name which triggers the data to display
on the line graph.

Any suggestions would be greatly appreciated! I have tried to search for
"selectable data", "dynamic charts", etc. and can't seem to find what I need.
I am not an Excel expert but I work with the program daily.

Best regards.

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 38 towards the top of my home page.

As far as I can see this will give you what you want.

If it isn’t exactly what you want I can amend it for you.

Rather than go through a long written explanation here as to how it works
email me and I will give you my contact details and / or set up a SKYPE
connection so that you can talk to me direct.

If my comments have helped please hit Yes.

Thanks!



"RGoad" wrote:

> I am trying to create a chart for use in the hotel industry. I have 24
> hotels that I would like to chart future room rates over the course of a
> month. I want the ability to select the hotels I would like to compare on a
> line graph. Possibly check the hotel name which triggers the data to display
> on the line graph.
>
> Any suggestions would be greatly appreciated! I have tried to search for
> "selectable data", "dynamic charts", etc. and can't seem to find what I need.
> I am not an Excel expert but I work with the program daily.
>
> Best regards.