ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I set up tracking chart (https://www.excelbanter.com/setting-up-configuration-excel/97503-how-do-i-set-up-tracking-chart.html)

Louisa

How do I set up tracking chart
 
I am trying to set up chart to record author, book name, date, CD/read, and
brief comments. I would like to be able to quickly determine if I have
already read a book in question and/or review comments of previously read
books. Is there a way I could do this using Word? Thanks for any info.
--
Louisa

Pete_UK

How do I set up tracking chart
 
You might like to post this to one of the Word newsgroups, as this one
is for Excel.

However, you could do this easily in Excel, if, by "Chart", you mean
"Table" - simply enter your titles into cells on row 1, move the cursor
to A2 and choose Window | Freeze Panes, then enter your data into the
appropriate columns for each book. You can adjust the width of each
column by double-clicking the vertical line(s) which separate the
column identifying letters (A, B, C etc). You could set up filters on
each column by choosing Data | Filter | Autofilter (check), and then
you can easily search for books and review comments etc.

Hope this helps.

Pete

Louisa wrote:
I am trying to set up chart to record author, book name, date, CD/read, and
brief comments. I would like to be able to quickly determine if I have
already read a book in question and/or review comments of previously read
books. Is there a way I could do this using Word? Thanks for any info.
--
Louisa




All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com