Hi,
I humbly seek help and tips to plot a grid based on the value entered. For instance, size 31" to be plotted into 3 vertical lines and 43" to be cut into 4 horizontal lines. Please refer to my attachment for better understanding.
Hi,
I humbly seek help and tips to plot a grid based on the value entered. For instance, size 31" to be plotted into 3 vertical lines and 43" to be cut into 4 horizontal lines. Please refer to my attachment for better understanding.
Please show expected output..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi,
The required output is the grid consists of 12 boxes. Sorry for the confusion. Thank you.
you can use a combination chart, column/bar, and 2 named ranges.
Hi Andy,
Can I have the horizontal lines visible? You can refer to my screen shot which I want them to appear (red lines). Thanks in advance.
Last edited by seanyeap; 07-10-2013 at 10:08 AM.
Secondary axes gridlines are not available in older versions of excel.
Instead you can make use of the border of the data series.
It helps to add your excel version to your profile, especially for charts and new solutions using new features.
Hi Andy,
It is marvelous!!!
Hi Andy,
Can I ask for a more complex grid? Please see the attached file. Thank you.
then you would need code to build that, or xy-scatter if using a chart.
The complicated thing would be knowing how to divide up the space.
I am not able to write codes and I know it is not easy. anyway, thanks for the effort and assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks