In the existing chart The Galactic Center tab I'd like help to create 2 additional charts/graphs
The existing xyz scatter but in 3d
And a version of the scatter that converts the dimensions into time and adds the Hex 4 coordinate so a location can be generated.
1 hexadecimal hour = 1000 = 4096 = 1 h 30 min
1 hexadecimal maxime = 100 = 256 = 5 min 37.5 sec
I am not sure I understand what you are trying to do. It looks like you are trying to create a 3D scatter chart. Unfortunately, Excel does not have a built in 3D scatter chart. This is the best tutorial I have found for simulating a 3D scatter chart in Excel: http://andypope.info/charts/3drotate.htm
I also am not sure what you are trying to do with the unit conversion to time and how that should be charted. However, it seems to me that, once you figure out the correct formulas to perform the unit conversion (unit conversions are usually simple multiplication or division formulas) in the spreadsheet, then it should be easy to add those to a chart as well.
Originally Posted by shg
Trying to see if it is possible to make a radar too with the same xyz dimensions too
I just looked at it and the 3d scatter is not what I am looking for.
What I need to get to work is the Polar Plot. I could then convert the xyz to time/distances.
I am not seeing how to properly polor plot however. Using the addin I still do get it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks