Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Due to spam on this forum, all posts now need moderator approval.
Entire forum
➜ MUSHclient
➜ Lua
➜ How to add series to an excel chart through lua
|
How to add series to an excel chart through lua
|
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Ptar
(3 posts) Bio
|
| Date
| Sat 27 Jul 2013 04:25 AM (UTC) Amended on Sat 27 Jul 2013 04:36 AM (UTC) by Ptar
|
| Message
| I've output several pairs of columns to excel with x and y data that I want to present as a single chart in excel. I've found examples of how to make a chart of single series of data using range, but not how to add multiple series. I'm looking to do something like:
local excel = luacom.CreateObject("Excel.Application")
local chart = excel.Charts:Add()
chart:AddSeries("=SERIES(Sheet1!$A$1,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,1)")
chart:AddSeries("=SERIES(Sheet1!$C$1,Sheet1!$C$2:$C$10,Sheet1!$D$2:$D$10,2)")
chart:AddSeries("=SERIES(Sheet1!$E$1,Sheet1!$E$2:$E$10,Sheet1!$F$2:$F$10,3)")
Anyone know how to do this? | | Top |
|
| Posted by
| Ptar
(3 posts) Bio
|
| Date
| Reply #1 on Sat 27 Jul 2013 04:31 AM (UTC) Amended on Sat 27 Jul 2013 04:38 AM (UTC) by Ptar
|
| Message
| |
| Posted by
| Fiendish
USA (2,558 posts) Bio
Global Moderator |
| Date
| Reply #2 on Sat 27 Jul 2013 05:05 AM (UTC) |
| Message
| | What does this have to do with MUSHclient? |
https://github.com/fiendish/aardwolfclientpackage | | Top |
|
| Posted by
| Ptar
(3 posts) Bio
|
| Date
| Reply #3 on Sat 27 Jul 2013 06:16 AM (UTC) |
| Message
| | Isn't this the lua scripting section of the forum? | | Top |
|
| Posted by
| Fiendish
USA (2,558 posts) Bio
Global Moderator |
| Date
| Reply #4 on Wed 31 Jul 2013 02:47 PM (UTC) |
| Message
| | Sure, but this is pretty specifically a MUD experience scripting forum. Are you even using MUSHclient for this? |
https://github.com/fiendish/aardwolfclientpackage | | Top |
|
| Posted by
| Nick Gammon
Australia (23,173 posts) Bio
Forum Administrator |
| Date
| Reply #5 on Wed 31 Jul 2013 11:01 PM (UTC) |
| Message
| There's a Lua mailing list, if this is nothing to do with MUD games.
http://www.lua.org/lua-l.html |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.
20,458 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top