Search results

Luke, in my original sheet the first three columns (automatically updated) contains the basic informations for the others columns which are manually typed, so I need to have the whole information in one single sheet. The problem is when the sheet is updated with more data all the automatic data...

Dear Chandoo, I've got a problem. I have a worksheet which has hybrid columns. The first three columns are daily automatically updated by a data conexion. I have to fill manually the others columns data. In the day after, when the data conexion brings new data to the worksheet, all the data...

Hi, I have built a line chart from a pivot table (dynamic table) and then smoothed the lines. The matter is that everytime I update the chart, the smooth format is lost and all the lines turns to straight angles again. How to keep the smooth line without losing its format when updating...

Hi Chandoo I have a folder in which there are a lot of excel files. These excel files are very similar among then (just month and years differ one another). I'd like to know how to extract the NAME of all files into a excel worksheet. Cheers Krinsom

Hallo, I have a text (a normal text) in which I´d like to insert a value, insert a number in between this text, a number which is in another cell . This number changes every month. How do I do that? Cheers Krinsom

hello Chandoo, What´s the best way to publish Excel Dashboards on the Web? Cheers Krinsom

Thank you, Thank you, thousand times thank you. Cheers Mario

Hi Chandoo, First of all I´d like to say that your web site is absolutely marvelous and it has helped me a lot! I have some data that I need to plot a chat showing just one serie at time, just like this sample (http://peltiertech.com/WordPress/display-one-chart-dynamically-and-interactively/)...