Prev: making a chart complicated
Next: How do I select color for levels within an organizational chart?
From: AnnieK on 25 May 2010 09:08


"GTblearch" wrote:

> That's unfortunate. I often develop complicated models that are viewed and
> used by people with much less Excel-saviness. Those buttons were extremely
> user-friendly and allowed my clients to play around with the numbers and know
> exactly what they were looking at. I hope that they return in the next
> version.
>
> - BRL
>
> "Debra Dalgleish" wrote:
>
> > Unfortunately, it's not addressed in Excel 2007.
> > You could add a title to the chart that links to a worksheet cell, and
> > show the selected date that way.
> > For example, if the date filter is in cell B3, select the chart title,
> > and type an equal sign. Then, click on cell B3, and press Enter
> >
> > Russ wrote:
> > > Hi Debra,
> > > I have just posted my own question on this and then found this thread. My
> > > specific problem is that if the chart is printed or viewed by less
> > > experienced users it's not obvious how the data is filtered. When the buttons
> > > were visible so was the filtering data, how is this addressed in 2007?
> > >
> >
> >
> > --
> > Debra Dalgleish
> > Contextures
> > www.contextures.com/tiptech.html
> > Blog: http://blog.contextures.com
> >
> >
From: AnnieK on 25 May 2010 09:38
I am not happy about not having the same if not better functions as 2003; I
feel that I have been short changed. I upgrade for better functions not less.
I am not the best chart maker but I did some impressive Pivot charts, they
were so easy. There is a fantastic product called Xecelsius that uses your
Excel spreadsheets as a source data. Its part of the Crystal Report Solutions
owned I think by SAP. So far I am doing ok self learning (as mentioned I am
not a great charter). Those of you with good chart skills would master it in
the blink of an eye. I am sure it is expensive but they allow you a 30 day
trial. If you like it and I am sure you can impress the boss who will more
than likely want it. Ufortunately MS have dropped the ball on this one.

"AnnieK" wrote:

>
>
> "GTblearch" wrote:
>
> > That's unfortunate. I often develop complicated models that are viewed and
> > used by people with much less Excel-saviness. Those buttons were extremely
> > user-friendly and allowed my clients to play around with the numbers and know
> > exactly what they were looking at. I hope that they return in the next
> > version.
> >
> > - BRL
> >
> > "Debra Dalgleish" wrote:
> >
> > > Unfortunately, it's not addressed in Excel 2007.
> > > You could add a title to the chart that links to a worksheet cell, and
> > > show the selected date that way.
> > > For example, if the date filter is in cell B3, select the chart title,
> > > and type an equal sign. Then, click on cell B3, and press Enter
> > >
> > > Russ wrote:
> > > > Hi Debra,
> > > > I have just posted my own question on this and then found this thread. My
> > > > specific problem is that if the chart is printed or viewed by less
> > > > experienced users it's not obvious how the data is filtered. When the buttons
> > > > were visible so was the filtering data, how is this addressed in 2007?
> > > >
> > >
> > >
> > > --
> > > Debra Dalgleish
> > > Contextures
> > > www.contextures.com/tiptech.html
> > > Blog: http://blog.contextures.com
> > >
> > >
 | 
Pages: 1
Prev: making a chart complicated
Next: How do I select color for levels within an organizational chart?