|
Post by codenut on Oct 11, 2004 15:45:09 GMT -5
Since my question is alittle different than the other question asked about tables......I'll just makes a different thread . I use Excel for data keeping and I'm trying to see if their is a Macro / different way to make what is on my webpage. It's just takes me too long to make those tables and I know a macro would solve the time it takes me to make the chart. -Steven
|
|
|
Post by Drew on Oct 11, 2004 20:30:22 GMT -5
Not sure what you mean by a "different way"...
Do you mean like add +1 to to the "weeks on" column and updating the "peak" column automatically?
|
|
|
Post by Drew on Oct 11, 2004 20:41:41 GMT -5
If that's what you mean then, yes there is a way with macros. I can post an example, if you want.
|
|
|
Post by codenut on Oct 11, 2004 20:54:00 GMT -5
If that's what you mean then, yes there is a way with macros. I can post an example, if you want. Oh I know how to do that I mean making a chart from Excel using Macros so I can put it up on my webpage
|
|
|
Post by Drew on Oct 11, 2004 21:19:19 GMT -5
Oh I know how to do that I mean making a chart from Excel using Macros so I can put it up on my webpage You mean like a graph type of chart? not a personal chart which is still an excel table.
|
|
|
Post by codenut on Oct 11, 2004 21:28:44 GMT -5
You mean like a graph type of chart? not a personal chart which is still an excel table. *tries to figure this out in head* LOL..............a personal chart which is still an excel table is what I'm looking for
|
|
|
Post by Drew on Oct 11, 2004 22:18:10 GMT -5
*tries to figure this out in head* LOL..............a personal chart which is still an excel table is what I'm looking for I'm not grasping what you're saying. Here's an example of how to create an excel chart with a macro... don't think this is what you want though: With ActiveSheet.ChartObjects.Add _ (Left:=100, Width:=380, Top:=80, Height:=230) .Chart.SetSourceData Source:=Sheets("Sheet1").Range("A3:G13") .Chart.ChartType = xlXYScatterLines End With
|
|
|
Post by Drew on Oct 11, 2004 22:22:20 GMT -5
If you mean saving your chart as a webpage, then you can go to "save as..." and select "Web Page (*.htm; *.html)" in the "save as type" area... and it will be saved as a webpage.
Also, what version of Excel are you using? If you're using Excel XP or better, then you can save as html. If not, then you may have to copy your table into word and then save as html.
|
|
|
Post by Drew on Oct 11, 2004 22:30:24 GMT -5
*tries to figure this out in head* LOL..............a personal chart which is still an excel table is what I'm looking for If you want to copy the contents of your excel table into another html editing program where you make your webpage, then you can just Copy & Paste. What html editing program are you using? If you're using FrontPage or Dreamweaver, everything should copy just as you have it in Excel.
|
|
|
Post by codenut on Oct 12, 2004 6:33:42 GMT -5
Can you tell how hard it is to explain? s9.yousendit.com/d.aspx?id=B7D3805DEB461C8BF443B83EF33AEFA6^ That's the spreadsheet that I use I'm trying to make it so I can make a chart by placing the right columns from this sheet into a different spreadsheet, then using the macros to customize it with boards, colors..........shit like that
|
|